Excel VBA: How to define column in range with variable

[simontop]

Hello,
I know that with e.g. a LONG variable LastRow, I can define the last row in a range like this:

Range("A6:" & LastRow & "10")

On the other hand this does not work:

Range("A6:J" & LastColumn)

What am I doing wrong?

 

[simontop]

Just when I posted the question.
This seems to work but seems rather complicated:

Range(Cells(1,6), Cells(10,LastColumn))

 

[Weaver]

That's how I would've done it.

although if your first cell is A6, it should be:

Range(Cells(6,1), Cells(10,LastColumn))

Although, if the first cell won't change, you can mix it up

Range("A6", Cells(10,LastColumn))

 

[simontop]

Thx, for some reason I can't get used to the thought, that you can mix addressing systems in VBA.

Oh and you're right about 1,6 vs. 6,1...