Share via

Where is Visual Basic for Excel

Anonymous
2022-07-22T01:48:44+00:00

I have Office 365 and trying to do spreadsheet data compare cell by cell in Excel. I found a small VB macro to try, but I don't have or can't find Visual Basic. Where is it so I can download?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

10 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-22T02:26:45+00:00

    Hello RonGorman

    I'm Diane, an M365 Apps & Services MVP and I’m happy to help you today.

    VBA is enabled in Excel - you will need to change the VBA macro security settings in File > Options > Trust Center > Trust Center Settings. Set it on Enable VBA macros (not recommended; potentially dangerous code can run) for now - if you only need the macro once, change it the security after you run the macro. If you need the macro frequently, you can selfsign it.

    Next: back in File > Options > Customize Ribbon, add a check in front of Developer. (on the right) You can open the VB Editor from there or using Alt+F11

    Right click on a sheet or the workbook name, choose Insert > Module. Paste the code into the module.

    Microsoft's article on how to run a macro:
    https://support.microsoft.com/office/run-a-macro-5e855fd2-02d1-45f5-90a3-50e645fe3155

    -- Diane

    Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-07-22T21:08:48+00:00

    Re: "I am having a row alignment issue"

    My first take on what you posted is that the "Cells" cell is merged.
    If so, unmerge all cells and run it again.

    I will take a look at the code to see what it does to merged cells.

    If the issue in not a merged cell(s), please post again.

    Thanks for letting me know.

    '---
    Nothing Left to Lose

    0 comments
  3. Anonymous
    2022-07-22T20:59:12+00:00

    I am having a row alignment issue. Great tool but the results show a 1 row out of alignment resulting in the entire comparison to be in error. I have checked and double checked the values and format for each row and column in each worksheet. Here is a sample of what I see in the Compare results. What am I doing wrong?

    WORKSHEET COMPARE:  287760  cells do not agree.
    All differences are shown - except format differences.
    Type of Cells Compare to CLEANED.xlsm CLEANED up 2022.xlsx
    Difference Sheet1 Sheet1
    Numeric A2 5286409 4331858
    Numeric A3 4331858 4865952
    Numeric A4 4865952 4726529
    Numeric A5 5237719 3662468
    Numeric A6 4726529 1889336
    Numeric A7 2653641 4037493
    0 comments
  4. Anonymous
    2022-07-22T20:56:52+00:00

    I am having a row alignment issue. Great tool but the results show a 1 row out of alignment resulting in the entire comparison to be in error. I have checked and double checked the values and format for each row and column in each worksheet. Here is a sample of what I see in the Compare results. What am I doing wrong?

    WORKSHEET COMPARE:  287760  cells do not agree.
    All differences are shown - except format differences.
    Type of Cells Compare to CLEANED.xlsm CLEANED up 2022.xlsx
    Difference Sheet1 Sheet1
    Numeric A2 5286409 4331858
    Numeric A3 4331858 4865952
    Numeric A4 4865952 4726529
    Numeric A5 5237719 3662468
    Numeric A6 4726529 1889336
    Numeric A7 2653641 4037493
    0 comments
  5. Anonymous
    2022-07-22T04:15:45+00:00

    Re: "I have Office 365 and trying to do spreadsheet data compare cell by cell in Excel."

    The free workbook "Professional_Compare" will do a cell by cell or row to row

    comparison of two worksheets. The vba code is built-in...

    Download from OneDrive...

    https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU

    '---
    Nothing Left to Lose

    0 comments