I am "self voting" this my most provincial question to date but I can't figure it out. I have tried youtube and the usual places to get this kind of question asked.
I have a huge spreadsheet filled with VBA code from one end to the other.
In sheet19 I am trying to call a sub (not private) that is in sheet2.
My code goes something like this:
call SubS2 'Sub from Sheet2 and it is not private so it should work
So I know that I am doing something so silly that it hurts.
I have tried call sheet2.SubS2....and that does not work.
Any help is much appreciated.
Any cheap shots are surely warranted. :)
thanks for your help!