Excel - How to select multiple columns as a range

Question

I hoped and guessed we could probably have something like this:

ws.Range("D").VerticalAlignment

Which appeared to be wrong a bit later.

Edit: previously in question I mentioned:

ws.Range("A:F").VerticalAlignment

And given a feedback which mentioned that was correct.

As you might see, I'm going to select the whole columns of A to F, what could be the right way doing so?

At least one of these caused error for me, so I thought there could be problems on calling these "Named Ranges", if what I mentioned in my comment is wrong tell me to update the question, thanks — Kasrak, Jul 18 '17 at 12:15
I would recommend against using multiple periods (.) on the same line - see https://stackoverflow.com/a/158752/34092 . — mjwills, Jul 18 '17 at 12:18

score 2 · Answer 1 · answered Jul 18 '17 at 12:19

Hi this confused me a bit when I needed to do it as well. I'll do my best to explain!

You can select single cells (still classed as a Range I believe) using

WorkSheet.Cells[row, column]

To select multiple Cells you could do something like this

Range startCell = excelSheet.Cells[1,1];
Range endCell = excelSheet.Cells[3,3];
Range myCellCollection = excelSheet.Range[startCell, endCell];

Hope that helps a bit!

Let me know if you want any more clarification, it may not be the most efficient way but it is still running in my application :)

score 1 · Accepted Answer · answered Jul 18 '17 at 12:16

1

As you have done is fine, but you haven't passed an argument to VerticalAlignment, assuming ws is set correctly too.

Range("D:D").VerticalAlignment = xlVAlignCenter
Range("A:F").VerticalAlignment = xlVAlignTop

As a few examples.

answered Jul 18 '17 at 12:16

Tim Wilkinson

score -3 · Answer 3 · answered Jul 18 '17 at 12:19

-3

How about selecting A1:F1 then use

activecell.EntireColumn.select();

answered Jul 18 '17 at 12:19

Ali BAGHO

Because using `select` is very bad practice and should avoided where possible. – Tim Wilkinson Jul 18 '17 at 12:25
@TimWilkinson Thank you, will not use it again! – Ali BAGHO Jul 18 '17 at 13:14

3 Answers3