Selecting Cell Range in VBA

[AndrewKent]

Hi there,

Basic question for you all:

.Range("A1:B10").select

How would I write this in this format?

.Cells(1, 1).Value (which is simply A1?)

Cheers,

Andy

 

[RoryA]

Do you mean:

.Range(.cells(1, "A"), .cells(10, "B")).select