Thread: Hidding Columns with R1C1
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Hidding Columns with R1C1
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
Reply With QuoteReply With Quote