JTech,

I think...

Range(InputBox("Please enter a range of cells")).Select

....might work

But you would have to type in...

C1:C3

....to get it to work like that.

You could also try...

C1.C3

....to try to help speed things up. (when entering formulas in cells, you
can use the period/dot/decimal point on the number pad in place of the colon
when you type in range references. typing a period is a lot quicker than
typing a colon, especially if you hand is already over there using the
number pad to type in row numbers in the range references.) I don't know if
the period-in-place-of-the-colon trick will work in this way. Try it and
let me know.

HTH,

Conan




"JTech" wrote in message
...
Would it be possible to use a vba input box to do the cell selection?
For example could I use it to pick c1 through c3?

If not is it possible to select cells b1 through b4 (cells that
contain amounts) and then put something like received in the
corresponding c1 through c4 cells? I am trying to find a way to
automate this very time consuming inventory task. See wishful example
below:


I would like to select the cells that have the amounts 1 and 4 in
them and run macro/vba code that would fill in the corresponding
cells with Text Like "Received".


Amounts Status
1 Received
4 Received
6 Received
7


Highlighting them allows me to see the total in the Sum Area of Excel.
Once I have selected the amount of Items that I know have come in, I
would activate the Macro.