Previous Topic Next Topic

Select a subset of cells within a row

Solved/Closed
Mario - Sep 5, 2008 at 09:46 AM
 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

1 response

Answer 1 / 1
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
17
Mario
Sep 8, 2008 at 03:41 AM
Thanks very much.

You suggestion is "Spot On".
0
archaic
Sep 14, 2010 at 01:44 AM
why the ActiveCell change to activecell when I type in my vb? n it says that object or with block variable not set.. =(
0

Similar discussions

Why can't I bridge connect?
ryno -
Qiqi -

15 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses