Select a range of columns based on active cell
 

Cells(ActiveCell.Row,"H").Resize(1,20).Select

or
ActiveCell.Offset(0, 7).Resize(1,20).Select

--
Regards,
Tom Ogilvy

"Steve" wrote in message
news:3fafc07f$0$22368$afc38c87@...
Hello everyone. I am trying to select columns H:AA of the row that the
active cell is on. I can select column H with the code snippet below, but
I
don't know how to select a range:

ActiveCell.Offset(0, 7).Activate

Thank you in advance!!

-Steve