lets say the value of cell A1 = $J$2:$J$5 then how do i tell a a macro to select this range
Z Zygan Jun 14, 2006 #1 lets say the value of cell A1 = $J$2:$J$5 then how do i tell a a macro to select this range
L Leith Ross Jun 14, 2006 #2 Hello Zygan, If you are referring to a VBA macro, the code would be... Sub Test() With ActiveSheet Range(.Range("A1")).Select End With End Sub Sincerely, Leith Ross
Hello Zygan, If you are referring to a VBA macro, the code would be... Sub Test() With ActiveSheet Range(.Range("A1")).Select End With End Sub Sincerely, Leith Ross
P Paul Lautman Jun 14, 2006 #3 Zygan said: lets say the value of cell A1 = $J$2:$J$5 then how do i tell a a macro to select this range Click to expand... In general in macros you should not have to select ranges. Instead just create range objects.
Zygan said: lets say the value of cell A1 = $J$2:$J$5 then how do i tell a a macro to select this range Click to expand... In general in macros you should not have to select ranges. Instead just create range objects.
