Hi
have a look at inputbox in the VBA help

--
Regards
Frank Kabel
Frankfurt, Germany


Unday wrote:
In Lotus 1-2-3 I was able to program into a macro to promp for
data(i.e. a range to copy data to). I haven't been able to do that
in excel 97. I know there must be a way. Can anyone help me?

Regards,

Unday