gscarter
07-28-2008, 06:00 AM
Hi,
If i have an integer J, which is my column reference and i want to highlight/select range A1 to (integer)J4, how do i go about referencing J as a column.
J = 8
Range("A1:" & J & "4").Select
Above is what im trying to do, but obviously doesnt work.
Ive also tried:
J = 8
Range("A1:" & Columns(J) & "4").Select
and:
J = 8
Range("A1:" & Cells(4, J)).Select
But i just cant seem to find a method that works.
Any help is appreciated.
Thanks
gary
If i have an integer J, which is my column reference and i want to highlight/select range A1 to (integer)J4, how do i go about referencing J as a column.
J = 8
Range("A1:" & J & "4").Select
Above is what im trying to do, but obviously doesnt work.
Ive also tried:
J = 8
Range("A1:" & Columns(J) & "4").Select
and:
J = 8
Range("A1:" & Cells(4, J)).Select
But i just cant seem to find a method that works.
Any help is appreciated.
Thanks
gary