Macro won't copy to Sheet4 always goes to last sheet in the workbook?

**bkanealy** · 10-24-2014, 02:49 PM

All,

I have the same code for a macro that copies to Sheet3 and does a fine job; however, this ALWAYS copies to the last sheet in the workbook. I'm a newb, but I just can't understand why the one works going to sheet3, but this stinker always goes to the last sheet. TIA

Brian

Please Login or Register  to view this content.

**stnkynts** · 10-24-2014, 02:59 PM

"Sheet4" as you are using it is actually a indexing function. For example Sheets("Sheet4") and Sheet4 are completely different (Technically they could be the same sheet but they are different in approach). If you know your specific sheet name that you want the data applied to it would be best to specify it in this format

Please Login or Register  to view this content.

**bkanealy** · 10-24-2014, 03:39 PM

Thanks!!!!

Macro won't copy to Sheet4 always goes to last sheet in the workbook?

LinkBack

Thread Tools

Rate This Thread

Display

Macro won't copy to Sheet4 always goes to last sheet in the workbook?

Re: Macro won't copy to Sheet4 always goes to last sheet in the workbook?

Re: Macro won't copy to Sheet4 always goes to last sheet in the workbook?

Thread Information

Users Browsing this Thread

Similar Threads

macro for copy sheet in another workbook

[SOLVED] macro to copy rows from a sheet in one workbook to a sheet in a different workbook...

Macro to copy first sheet from other non opened workbook - let user choose which workbook

Macro, copy UNLOCKED cell range of sheet in open workbook to workbook template

Copy Sheet to another workbook with macro

Bookmarks

Bookmarks

Posting Permissions