Quick Help w Macro

Hi all, I have the following macro in place - it's giving me the subscript out of range error when I run it. is there something wrong with this (recorded) code?



Thanks for any help in advance!

Sub photo()
'
' photo Macro
'

'
    ActiveWindow.ActivateNext
    ActiveWindow.ActivateNext
    Cells.Select
    Selection.Copy
    ActiveWindow.ActivateNext
    ActiveWindow.ActivateNext
    Sheets("Photo Documentation").Select
    Cells.Select
    ActiveSheet.Paste
    Range("E71").Select
    ActiveWindow.SmallScroll Down:=3
End Sub

1) merit:
instead of

ActiveWindow.ActivateNext
ActiveWindow.ActivateNext

you may try (if workboooks are open in one excel instance - but probably they are not):

Worbooks("myworkbookname.xlsx").activate

if in several separate instances (more probable in your case), it will be a bit more complicated.
Nice (but not too simple) solution - see https://stackoverflow.com/questions/...ances-of-excel ) or simpler: https://www.mrexcel.com/forum/excel-...ml#post1074378

2) administrative (also very important):
Please DO read and follow our https://www.excelforum.com/forum-rul...rum-rules.html
This is short set of rules. But in one post you broke two (1st and 3rd). Please edit your post and correct title + use code tags

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)


Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)