dutchdscooper
New Member
- Joined
- Dec 20, 2016
- Messages
- 3
I need code to delete rows in 16 different sheets if the cell value in column F is zero. The headers are all on row 2 so data starts on row 3. The data ranges for each tab are always changing and never the same so need special range coding to identify where the data range ends (column A can be used to determine when the range has ended).
Also, I'm hoping the macro can run quickly and smoothly. I have attempted a bunch of different codes but all either don't function properly after the first sheet, take longer than it would for me to filter to zeros and delete manually (some sheets have thousands of rows of data and certain code was literally going line by line taking forever on 1 sheet much less 16 sheets).
Your assistance is greatly appreciated!
Also, I'm hoping the macro can run quickly and smoothly. I have attempted a bunch of different codes but all either don't function properly after the first sheet, take longer than it would for me to filter to zeros and delete manually (some sheets have thousands of rows of data and certain code was literally going line by line taking forever on 1 sheet much less 16 sheets).
Your assistance is greatly appreciated!