Hiding 3 columns using R1C1 format

I need to specify 3 columns to hide specified as col i thru i + 2.

Please Login or Register  to view this content.

this doesnt work - gives me a error on the selection line (unable to set the hidden property of the range class).

Hate to bother you guys with this simple of a problem!

I personally found it simpler to use Range.

Range("A:A").entirecolumn.hidden = true

Try this. Same result I believe.

Franck,
I use the R1C1 notation because I am in the middle of a do loop where I am calculating the columns. So I know the column is a number named "colnum" variable. So how can I specify that column in a column select statement in R1C1? I can't say (1,colnum) because that will hide only row 1.
Thanks

I'd need to see a snippet of the loop you're currently in to see what variables you're working with. There should be a way depending on that. I know I make lots of loops with variables, and I am able to target certain columns and rows depending on where I am.

For example, I can use offset :

Please Login or Register  to view this content.

This is just an example of course. I use lots of Offsets and Range combo in my own scripts. There might be better or more efficient ways, but this has worked for me.

I got it. you just use the r1c1 and specify row 1 because its a column command so it ignores row anyway.

Range(Cells(1, intSTartColNum), Cells(1, intEndColNum)).Select