I can't seem to spot the error in my code when I changed my Sheets(1) to Sheet1 in my code so that way I could have multiple sheets not included in the code. This code takes everything from Sheet1 and moves it to sheets i call ABQ 2015 & ABQ 2016 when it finds proper dates dates. I'm getting no errors but nothing is moving.
Please Login or Register to view this content.
There's no essential difference between Sheets(1) and Sheet1 if Sheets(1) is the leftmost tab and it also has the VBA Sheet Code Name 'Sheet1'.
Have you stepped through the code to see whether you ever enter the IF condition.
Otherwise upload the workbook.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There is a difference between Sheets(1) and Sheet1. Sheet(1) is the first worksheet tab, while Sheet1 is the name of a particular worksheet. Is it possible that your Sheet1 is not the 1st tabbed worksheet?
It's not the first tabbed worksheet it is the last. Is that what my problem is?
EDIT: Thanks Dangelor I had tabs in wrong order that was an easy fix.
Last edited by Dark0Prince; 01-10-2017 at 03:58 PM.
You missed the important bit where I said "if Sheets(1) is the leftmost sheet tab AND it also has the VB CODE name Sheet1"Originally Posted by dangelor
@DarkOPrince.
There are three ways of directly referencing a particular sheet.
1. Sheets(x) where x is an index number representing the number of sheets across the tab names starting with the left hand sheet. So Sheets(3) will be the third sheet from the left
2. Sheets(string) where string is the sheet tab name.
3. Sheetx where x is any integer. This is the VBA sheet code name.
You should always work with the VBA code name since the sheet tab name is too easily changed which will cause any code that uses it to fall over. Similarly avoid the sheet index number since a sheet tab can be dragged to another position on the bar that contains the sheet tab names.
Glad I could help! More importantly, Richard's advice is well worth heeding...
You should always work with the VBA code name since the sheet tab name is too easily changed which will cause any code that uses it to fall over. Similarly avoid the sheet index number since a sheet tab can be dragged to another position on the bar that contains the sheet tab names.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks