Range("B1").Resize(1, Range("A1").Value2).Select
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(Data Rows add-in: Custom Shading, Deleting, Inserting)





"kittronald"
wrote in message
...
I'm trying to create a macro that will do the following:

1) Goto B1

2) Using the variable number value stored in A1 (i.e., 10), select B1 and the next nine
adjacent cells to the right - creating a range of 10 selected cells (B1:B10).

The goal is to select an X number of cells from a known starting point.

Any ideas ?

- Ronald K.