View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

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