Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Little Macro help
My problem is that when I start recording with a macro I use Find to navigate
through my data. I'm using Find because I will be using different worksheets with different data. However, the starting locations of the data points are the same. So if I use Find "Start" and then use the cursor to go two boxes down and 9 boxes to the right, will the macro remember my cursor movements, or does it just remember the boxes locations that data is created? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Little Macro help
It will remember the final cells that you arrive at, not the rows/columns
traversed. If you try it, you will easily see these things. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Chris" wrote in message ... My problem is that when I start recording with a macro I use Find to navigate through my data. I'm using Find because I will be using different worksheets with different data. However, the starting locations of the data points are the same. So if I use Find "Start" and then use the cursor to go two boxes down and 9 boxes to the right, will the macro remember my cursor movements, or does it just remember the boxes locations that data is created? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |