Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel macro
can use this need to check for value etc in cell befor copy been trying to do
this with copy & paste in a macro. lot more code than here just need to validate. "Don Guillett" wrote: It does not have to pause unless you were asking for the value to lookup. use FIND to find it and copy to the new address. Example Sub findandcopy() Columns(1).Find("x").Copy Range("c12") End Sub -- Don Guillett SalesAid Software "CCB AA" <CCB wrote in message ... Writing a marco and I need a "pause" so I can copy info from another wookbook and insert it in the current wookbook. How do I make a macro pause, lookup, copy, insert and then move on? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Macro to close excel | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions |