Hide Column if Cell value is null ("")

[JBeaucaire]

I need a quick macro I can run to hide the columns if the formula result for cells B1:AA1 is "" (null) instead of text. This runs explicitly on Sheet2.

Array VBA is still geek to me, so any assistance is appreciated.

[shg]

Please Login or Register  to view this content.

[JBeaucaire]

Ah, that looked sweet and simple, but isn't working. Here is a sample formula from a cell in that range:

S1 =iferror(LEFT('Data-Nov07-08'!AJ1,FIND(" ",'Data-Nov07-08'!AJ1)-1),"")

So, the cell is returning a "" value. Also, the sheet name might weird out, so I was hoping to use Sheets(2) to eliminate that problem.

I tried:

Please Login or Register  to view this content.

The actual sheetname is currently Chart-Nov07-08, but that will most likely vary and I'd like to step off of the actual sheetname.

[JBeaucaire]

Well, some more fiddling, and for some reason THIS version started working:

Please Login or Register  to view this content.

Thanks so much!

[shg]

Sheets(2) is the second sheet in a workbook, counting chart sheets.

Worksheets(2) is the second worksheet in a workbook.

Sheet2 is a variable that exists iif there is a sheet with CodeName Sheet2.