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 answers without all the jargon. Just need clear instruction on how to make this work. I have a very large workbook, my budget, that relies on the Prevsheet function. I used it successfully in every version for years, simply paste into VBA and save. Office 365 does not seem to like it. Most recent version being used: Function PrevSheet(RCell As Range) Dim xIndex As Long Application.Volatile xIndex = RCell.Worksheet.Index If xIndex > 1 Then _ PrevSheet = Worksheets(xIndex - 1).Range(RCell.Address) End Function