ExcelBanter - Hidding Columns with R1C1

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Hidding Columns with R1C1 (https://www.excelbanter.com/excel-programming/374929-hidding-columns-r1c1.html)

Greg Glynn

Hidding Columns with R1C1

Gentlefolk,

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

Greg

Dave Peterson

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

Greg Glynn

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

All times are GMT +1. The time now is 08:33 AM.