Delete data based on value

[Sanecrazy]

Hi there,

I would like to know how to get VBA to look at the very last value in a column and if it is less than 1 delete all the data in that column. I want to do it for more than 1 column but ill just duplicate the code for each column?

Also can anyone recomend a good book or resource for someone like me who is new to vba to learn more about it in excel? im just starting out.

Cheers

G

[tom1977]

try such code:

Please Login or Register  to view this content.