Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting specific cells in a worksheet. | Excel Worksheet Functions | |||
how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
select worksheet to run macro | Excel Discussion (Misc queries) | |||
Sum of specific cells | Excel Worksheet Functions |