Hidding Columns with R1C1

  • Thread starter Thread starter Greg Glynn
  • Start date Start date
G

Greg Glynn

Gentlefolk,

Can I use R1C1 or CELLS() to hide columns by NUMBER rather than by
letter?

Greg
 
with activesheet
.cells(3,6).entirecolumn.hidden = true
'or
.columns(6).hidden = true
end with
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

R1C1 notation in VBA code 7
refedit controls and R1C1 notation 2
syntax in VBA to create a pivot table 2
Query then pivot table 6
Assigning Range Names using VBA and R1C1 6
Rank Data using VBA - having trouble with R1C1 notation 4
Pivot Table Macro with dynamic source data 1
Synchronize sheets by row? 3

Back
Top