BrianExcel
Well-known Member
- Joined
- Apr 21, 2010
- Messages
- 975
I have a named range, "FinalEditsRange".
I need to loop through the range and (1) delete all empty columns. Then, I need to loop through the last column in the range (the header is "Percent Edit" and delete any row that is empty or contains 0.
Is it possible to do both in one block of code?
I need to loop through the range and (1) delete all empty columns. Then, I need to loop through the last column in the range (the header is "Percent Edit" and delete any row that is empty or contains 0.
Is it possible to do both in one block of code?