VBA: Loop through columns

[gd6noob]

Hi everyone,

Just wanted to see what's the best method to loop though columns until last column.

E.g., My data set has between 5-8 columns (not the same each time) and I want to delete rows all the rows based on a value from a cell (which can be either blank cells, string or numbers)


Thanks in advanced

 

[My Aswer Is This]

Hi everyone,

Just wanted to see what's the best method to loop though columns until last column.

E.g., My data set has between 5-8 columns (not the same each time) and I want to delete rows all the rows based on a value from a cell (which can be either blank cells, string or numbers)


Thanks in advanced

Normally you should not need to loop through Columns.
Would you please give an example of what you're attempting to do.