Macro Range Selection

[Roy A.]

The the range select below I would like to be able to start the cursor in any
row and have it select columns A:C

Range("A16:C16").Select

Thanks for any assistance

 

[FSt1]

hi
you have answers under your post in programming.

FSt1

 

[Gary''s Student]

r = ActiveCell.Row
Range("A" & r & ":C" & r).Select

 

[Roy A.]

r = ActiveCell.Row

Range("A" & r & ":C" & r).Select

Thank you Gary, this worked perfectly.