Forum Discussion
Solved
Excel Macro Reference to Current Workbook/Worksheet, Not a Specific One
I do a CSV download of banking data from my online account. Those data must be reconfigured (deleting, adding, and combining columns; turning positive numbers into negatives; sorting; etc) to be pas...
Replace ALL occurrences of ActiveWorkbook.Worksheets("AccountHistory") with ActiveSheet
Replace ALL occurrences of ActiveWorkbook.Worksheets("AccountHistory") with ActiveSheet
Thanks HansVogelaar! Worked like a charm. I've got another macro question coming up. Keep your eyes peeled for it. :-)
