Forum Discussion
Macros tab selection
I have written a simple macro that deletes unwanted rows of data based on specific criteria. I dont always want the macro to run on the same sheet. how do I change it to reference the sheet I would...
still working on the Macro. I have several raw data sheets where I am trying to eliminate all non relevant rows. not all raw data sheets have the same number of rows.
So when recording my Macro, i key:
Home
Shift-End Down-Shift-End Right and that captures all the data for the sheet i am in. however when I stop recording and review the code, it show a specific cell range IE: $A$1:$W$500.
How do I correct the code so its not showing a specific cell reference.
