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
Bookmarks