Selecting a Row

[EdWoods]

Hi,

What am I doing wrong here?
I want to select Columns A - J of whatever row the cursor is on

   CurrentRow = ActiveCell.Row
   Range("A" & CurrentRow:"J" & CurrentRow).Select

I've tried putting brackets everywhere, and nothing seems to work.


Thanks

Paul

[ferday]

is that a copypasta? because your range is missing an &

this works for me

Dim c As Integer
Dim a As Range

c = ActiveCell.Row
Set a = Range("A" & c & ":J" & c)
a.Select

[EdWoods]

Awesome. Thanks for that.