Forum Discussion
PrevSheet in Office 365
I have tried several versions of the PrevSheet function, saving each into my workbook, but all return the same Ambiguous error. I am NOT a power user and barely motivate around VBA, looking for an...
I'm on Office365 (on a Mac though). Took your code as it is and copied it into a new VBA module. Works fine. Attaching a workbook with the code and some examples in it. Hope it works on your end as well.
The response is much appreciated, but it didn't work.
I have used this successfully for years, but only in workbooks running under excel on my machine. For some reason, I cannot get it to work using MSOffice 365. I get an error "Ambigous Name Detected: Prevsheet when trying to use it with 365.