Hi,
I have a file 1.xls & I want to copy all data from sheet1 and paste it to sheet 3
macro will be placed in macro.xlsm so the file path should be hardcoded in the macro
Thnx for the Help
Hi,
I have a file 1.xls & I want to copy all data from sheet1 and paste it to sheet 3
macro will be placed in macro.xlsm so the file path should be hardcoded in the macro
Thnx for the Help
It is not a good practice to name workbooks or sheets as single digit numbers only. It leads to confusion with index numbers which are automatically assigned by the Excel application.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
No problem, from next time I will keep in mind this info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks