Forum Discussion

unhappyuser's avatar
unhappyuser
Copper Contributor
Oct 01, 2019

Macro issue with email connectivity

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 lapt...
macro
unhappyuser's avatar
unhappyuser
Copper Contributor
Oct 04, 2019

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?

Smitty Smith's avatar
Smitty Smith
Former Employee
Oct 04, 2019

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.

Resources