ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Little Macro help (https://www.excelbanter.com/excel-programming/365562-little-macro-help.html)

Chris

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?

Bob Phillips

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?





All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com