I'm doing a simple clean up of a file that gets exported from our system. Since the clean up is so straight forward, I just did a record macro. At one point I have the macro select columns G:J and remove those columns. Then I tell the macro to select columns I:J and delete those. But instead of selecting I:J, it selects G:J again and deletes the data I needed that is sitting in G:H. I tried inserting a step where the macro selected a completely different cell, and THEN go select I:J, but sure enough, it went back and selected G:J again and deleted that data. Has anyone ever seen this before?
Here is my code:
Please Login or Register to view this content.
Bookmarks