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

Mario - Sep 5, 2008 at 09:46 AM - Latest reply:  archaic
- Sep 14, 2010 at 01:44 AM
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
See more 

3 replies

Best answer
Ivan-hoe 436 Posts Saturday February 16, 2008Registration date October 17, 2008 Last seen - Sep 7, 2008 at 01:46 AM
17
Thank you
With ActiveCell
    Range(Cells(.Row, "B"), Cells(.Row, "M")).Select
End With

Thank you, Ivan-hoe 17

Something to say? Add comment

CCM has helped 1692 users 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.. =(