hide columns macro
There isn't supposed to be a line break after Then - if you do have one you
will need an END IF after the next line.
Jeff
"Jeff Standen" wrote in message
...
For a = 0 To 255 'Change this if you don't need it to do every column if
the sheet
If Range("a65536").Offset(0, a).Value = "0" Then
Range("a65536").Offset(0, a).EntireColumn.Hidden = True
Next a
"xkarenxxxx" wrote in message
...
I want to write a macro which hides columns if the value in the bottom row
of
the column is 0.
Can anyone help?
|