hide column
 

if you don't want to scan all 256 columns, you can get the last column with :
iLastCol=wks.UsedRange.SpecialCells(xlCellTypeLast Cell).Column
then loop :

for i=1 to iLastCol ...


"Steph" wrote:

Hi. Is there a way to have vba scan every visible worksheet, and look in
row 3. If there is a 1 in a cell in row 3, hide that column? Thanks!