Search results

Yes, the macro works just fine when I run it within excel itself. I assign handle 0 to the macro file, and handle 1 to the Data.xlsm file. Maybe Run Macro doesn't work the way I think it does, or I'm just mistaken on my syntax when trying to use it.

Hello, I have used macros in Excel before, but in the past they were always used on nice worksheets that had the macros ingrained. I have a different situation now though, and can't seem to wrap my head around it. For setup, I have 2 documents I have created: 1. Data.xlsx (which I am manually...