How do I pause a macro to select specific cells

I am using version Excel 2003 - I need to be able to pause a macro to allow
me to select specific cells (which will be different each time I use the
macro) then continue to run the rest of the macro.

You could use application.inputbox()

As in:

dim myRng as range

set myrng = nothing
on error resume next
set myrng = application.inputbox("Select a range", type:=8)
on error goto 0

if myrng is nothing then
'user hit cancel
'what happens here
else
msgbox myrng.address 'do what you want
end if

lee wrote:
>
> I am using version Excel 2003 - I need to be able to pause a macro to allow
> me to select specific cells (which will be different each time I use the
> macro) then continue to run the rest of the macro.

--

Dave Peterson