Hi,
Is it possible to have a macro which would remove the entire row if column F is ZERO and column G is blank. Also I would only want this to happen from rows 4 to 764
Any ideas would be perfect!
Thanks
Hi,
Is it possible to have a macro which would remove the entire row if column F is ZERO and column G is blank. Also I would only want this to happen from rows 4 to 764
Any ideas would be perfect!
Thanks
One way:
![]()
Please Login or Register to view this content.
Another would be to use autofilter.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Another example using autofilter which assumes you have headings in row 3:
![]()
Please Login or Register to view this content.
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks