Hidding Columns with R1C1
Thanks Dave ... Perfect.
Greg
Dave Peterson wrote:
with activesheet
.cells(3,6).entirecolumn.hidden = true
'or
.columns(6).hidden = true
end with
Greg Glynn wrote:
Gentlefolk,
Can I use R1C1 or CELLS() to hide columns by NUMBER rather than by
letter?
Greg
--
Dave Peterson
|