Select a subset of cells within a row [Solved/Closed]

Report
-
 archaic -
Hello,

I am trying to select a number of cells within a row - I want to use this in a macro.
Whatever cell is currently active, I want to select cells from column B to Column M in the current row.

Thanks, M

1 reply

Posts
433
Registration date
Saturday February 16, 2008
Status
Member
Last seen
October 17, 2008
109
With ActiveCell
    Range(Cells(.Row, "B"), Cells(.Row, "M")).Select
End With
17
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Thanks very much.

You suggestion is "Spot On".
why the ActiveCell change to activecell when I type in my vb? n it says that object or with block variable not set.. =(