Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste Problem
JB,
you can't record a macro to do this. What you can do is edit the recorded version to work the way you want. In the transcript of your recorded macro you will see the line Cells.Find(What:= ... after that equals, you will see the original string you searched on when recording the macro. If we assume that string was "Bill" and, instead, you always want to find the value in cell A1, then replace What:="Bill" with What:=Range("A1").value You can now simply amend the contents of cell A1 and run your macro with gay abandon. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem with copy and paste | Excel Discussion (Misc queries) | |||
copy and paste problem | Excel Discussion (Misc queries) | |||
Copy and Paste Problem | Excel Discussion (Misc queries) | |||
copy paste problem? | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) |