hi,

turns out there were some merged cells. ok here is another problem... so if
the column is ALREADY hidden, how can i add some error/process handling to
the following:

Columns("D").Select
Selection.EntireColumn.Hidden = True

thanks in advance,
geebee



"JLGWhiz" wrote:

Aside from possibly having merged cells somewhere in the column, I don't know
what would cause that. However, as a sidepoint, if you are selecting the
entire column you don't need the attenuation colon. Just do

Columns("D").Select

You only need the attenuation colon if you are selecting more than one column.

"geebee" wrote:

hi,

I have the following:
Columns("D:D").Select


for some reason columns C AND D are being selected?

why?

thanks in advance,
geebee