I'm having an issue with getting the MACRO to copy from the correct sheet when it is taking data from another excel work book. The issue is even though I have the sheet search on for the "TOP" it will copy form which ever sheet was last active when the excel was open. I currently have it set up to where each macro does its own section (TOP,BOTTOM,LEFT, RIGHT) so I know I have a bit of extra Dim information. If I can also kind of get a bit of an explanation as to why mine isn't working that would be a bonus.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
SELECTING THE CORRECT SHEET FROM ANOTHER EXCEL
- Thread starter budha465
- Start date
-
- Tags
- vba & code
Excel Facts
Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
