I think that's what I'm looking for. Forgot about <application.inputbox

D.S.

Donald
"Bob Phillips" wrote in message
...
Donald,

Using Application.Inputbox you can select a cell.

This code sets a cell to that value
myCell = Application.InputBox(prompt:="Select a cell", Type:=8)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"D.S." wrote in message
...
Anyone know how I can use the inputbox so that the value of the inputbox
is
determined by the cell I select with my mouse?

Donald