Set activecell_position = Application.InputBox
(prompt:="Input desired active cell position",
title:="Active Cell Position",
Default:=ActiveCell.Address, Type:=8)

set ActiveCell_position = activeCell_Position(1,1)

--
Regards,
Tom Ogilvy

Chris Gorham wrote in message
...
Hi,

I'm writing a macro that will improve on Excel's graph
plotting routine by automating some of the steps. As part
of it I would like to have the user select a row by
clicking on it.

No problem - I can do that:

Set activecell_position = Application.InputBox
(prompt:="Input desired active cell position",
title:="Active Cell Position",
Default:=ActiveCell.Address, Type:=8)

but what I would like to do is to prevent a range of cells
being highlighted accidentally.
ok, I know its still the active cell address that's read
in - but I want to prevent the highlighting of the range
in the first place.

Thks....Chris