Thread
:
Range("C9:V9").Select ==> changing the 9 to a variable
View Single Post
#
2
Don Guillett
Posts: n/a
mr=activecell.row
range(cells(mr,"c"),cells(mr,"v")).select
but almost always not necessary to select. So what are you doing with your
selection?
range(cells(mr,"c"),cells(mr,"v")).copy ???
--
Don Guillett
SalesAid Software
"B. F." wrote in message
oups.com...
I am defining the current selector row thru this statements:
Dim Currow As Integer
Currow = ActiveCell.Row
Now I need to change:
Range("C9:V9").Select
to a variable range definition where the 9 is substituted by the value
of the current row (Currow)
I tried several ways of doing it by always got a "wrong syntax" error
when executing.
Coud you please help me ?
TIA, Jorge
Reply With Quote