View Single Post
  #3   Report Post  
KL
 
Posts: n/a
Default

Try:

Range("C" & Currow & ":V" & Currow).Select

Regards,
KL

"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