Solved: Range Expression

[snoopies]

Hi,

Can anyone tell me the alternative way to express the following range?

Range("A3:A65536")

p.s I want to use "1" instead of "A"

Thanks!!

[Sir Newbie]

Hi snoopies

Does this help you?

I'm working on the assumption that you want to use an integer rather than a letter to reach your objective.


With Worksheets(1)
.Range(.Cells(3, 1), .Cells(65536, 1)).Borders.LineStyle = xlThick
End With


You might want to keep in mind that I'm a newb :)

Good luck.

Chow for now!

[Bob Phillips]

Range(Cells(3, 1),Cells(Rows.Count, 1))

[snoopies]

Hi both,

Thanks a lot!! :)