Click record, then
Ctrl + ACpgdn
on play back get a debug error and it appears the pgdn is the cause..
The "recording" part of automation doesn't record and play back keystrokes. It looks at what was done, and tries to produce code to replicate that using the API. Recording doesn't always produce code that works the way the user intended; lots of limitations there.
Sometimes you can't get where you want to be just by recording, and the job requires either manually modifying the code that was produced, or writing code from scratch.
Thanks, just using the inbuilt recorder which I assume creates VBA code..
sucks it wont recognise a pgdn...
If you want to see what has been recorded, you can look at the code in the VBA editor.
For some things, recording works great. Even when it works, though, it may produce code that is sort of weird compared to what one would write "from scratch" to do a particular task.
Would you be willing to describe exactly what you wish to automate?
Go to next page
and repeat until everpage is done.. could be up to 100 pages..
Do want to horizontally center objects relative to one of the objects? Or relative to the page?