Column Selection ...

[santeria]

This may or may not be as self Evident as it seems, but anyway, I wanted to Check...

Is the Selection of:

A:A,B:B,C:C, right down to Z:Z

In a macro, the Same as Selecting

A:Z

Within the Context of a Macro Selecting Columns?

Ta

 

[Mudface]

Yes.

 

[Cbrine]

This may or may not be as self Evident as it seems, but anyway, I wanted to Check...

Is the Selection of:

A:A,B:B,C:C, right down to Z:Z

In a macro, the Same as Selecting

A:Z

Within the Context of a Macro Selecting Columns?

Ta

I know that
Activesheet.columns("A:Z").select would select all columns from a to z
Activesheet.columns("A:A,B:B,C:C,....,Z:Z").select sounds like it does the same thing the hard way, but I don't use this syntax normally, so I can't be sure.

 

[santeria]

I am just trying to trim down the Large Macro I have so that selections are a bit more consistent.

I realise it may be a bit of a simple question, but I don't think it's as self-evident as it may seem.

Ta

 

[Cbrine]

FYI,
Your orginal syntax is far from useless though, if you wanted to select multiple sections that's how you would go.
ie. Activesheet.Columns("A:B,D:E,G:H").select
Would be like Pressing Ctrl and Hightlight Columns A and B, D and E, G and H.

 

[santeria]

Thanks.