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

Vba code to select entire row of active cell
Vba select case like - Guide
Battery reset code - Guide
How to get whatsapp verification code online - Guide
Samsung volume increase code - Guide
Cs 1.6 code - Guide

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

Mario
Sep 8, 2008 at 03:41 AM

Thanks very much.

You suggestion is "Spot On".

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.. =(

Similar discussions

Unlock code

How to unlock Gameloft games

lava hard reset & factory reset

Similar discussions

Subscribe To Our Newsletter!