Oct 01 2019 08:50 AM
so i have a macro that i send each day for work - it's on my excel spreadsheet. it's supposed to automatically send my pnl sheet to the designated people on email. it works fine on my home laptop, but here on this computer it doesn't work for some reason
not sure if it's because there is an issue that the email is not linked somehow? or that maybe my antivirus is blocking -
Oct 04 2019 10:42 AM
@Smitty Smith This is the line that pops up yellow
Sheets("ARB").Select...I clicked debug and I guess it's in process? That take a while? or should i try something else afterwards now?
Oct 04 2019 10:50 AM
@unhappyuser A subscript out of range error on that line indicates that 1) you don't have a sheet named ARB, and Excel throws an error because it can't find it, or 2) you have a sheet named something similar to "ARB", but not exactly, so again, Excel can't find it. Try putting an apostrophe in front of that line of code, which will turn it into a comment that VBA will ignore, and try stepping through again.
Just a heads up that it's generally not necessary to select sheets in code. But that line of code isn't in what you originally posted, so I'm not sure what's going on.