Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select data to imput to macro
Regarding the following macro, how do I tell the macro what data to work with
and transfer to one column? Or, how do I select the data and run the macro? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select data to imput to macro
You have at least a couple of choices.
You could have the user (you???) select the range first, then run the macro. Then your macro could work on the current selection. Or you could ask the user for the range in your macro: #1. Dim myRng as range set myrng = Selection #2. Dim myRng as range set myRng = nothing on error resume next set myrng = application.inputbox(Prompt:="Please select a range", type:=8) on error goto 0 if myrng is nothing then 'user hit cancel else 'do what you want end if But I'm not sure what you're really doing. sofast1651 wrote: Regarding the following macro, how do I tell the macro what data to work with and transfer to one column? Or, how do I select the data and run the macro? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select data to imput to macro
Hi,
I don't think your macro got through? -- Thanks, Shane Devenshire "sofast1651" wrote: Regarding the following macro, how do I tell the macro what data to work with and transfer to one column? Or, how do I select the data and run the macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
two-imput data table | Excel Worksheet Functions | |||
How do I get an excel macro to stop at a cell & wait for imput? | Excel Discussion (Misc queries) | |||
Data Validation, Invalid Data Imput | Excel Discussion (Misc queries) | |||
can not imput data on saved worksheet | Excel Worksheet Functions | |||
Is there a way of making data imput in to a cell mandatory before. | Excel Worksheet Functions |