Need VB for Excel 2010 for if than hide

Microsoft Excel 2010
January 20, 2011 at 10:06:31
Specs: Windows XP, Xeon 4 core / 4 gig
Hi ! looking for some help for some VB Code to check each line in collumn "C" and "D" and if both are blank to hide the row.

Anyone know how to do this ?

Thanks

Larry


See More: Need VB for Excel 2010 for if than hide

Report •


#1
January 20, 2011 at 13:27:56
re: "some VB Code to check each line in collumn "C" and "D" "

There are an awful lot of "lines" (rows) in an Excel 2010 spreadsheet. Are you sure you want to check every one of them?

I'm assuming that your data only uses a portion of the spreadsheet. If there is a column that will always have data down to the bottom of your data set, then we can use that column to determine how many rows that we really have to check.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question