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
Related:

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

lava hard reset & factory reset
AVAY -
Har -

3 responses