Microsoft Excel 2010

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

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.

Ask Your Question

Weekly Poll