Select a subset of cells within a row

Mario - Sep 5, 2008 at 09:46 AM
 archaic - Sep 14, 2010 at 01:44 AM

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 response

Ivan-hoe Posts 433 Registration date Saturday February 16, 2008 Status Member Last seen October 17, 2008 110
Sep 7, 2008 at 01:46 AM
With ActiveCell
    Range(Cells(.Row, "B"), Cells(.Row, "M")).Select
End With
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.. =(