COLUMN WIDTH
Posted by Nick on July 09, 2001 11:34 AM
I am trying to write a macro to hide a column if particular data is found in it.
I have tried using either
Columns(curCol).Hidden = True
Cells(row1, curCol).EntireRow.Hidden = True
but get the error message "Unable to set the hidden property of the Range class".
If I select the cell then I can get it to work, but this then looks ugly when the macro runs.
How can I hide a column without having to select it?