prevsheet

I inserted a Prevsheet function into VB and saved it to my personal workbook. I wanted it available to all workbooks later. Initially it would not run in any workbook - i had to try several different versions until one finally worked in budget spredsheet. I use it to carry totals over...

Hi, I'm hoping to use the UDF PrevSheet() to replace INDIRECT() for referencing data in previous sheets, TO AVOID IT BEING VOLATILE BUT the code for the macro says this is volatile too. Can I simple replace the line: Application.Volatile True with Application.Volatile False By which i...

Hi all, first post by a novice hope someone can help. We have a fleet fuel workbook with tabs for each month. Data arrives in .csv form and I straighten it out with a macro to clean up the columns and order it by vehicle registration. Each car fills up a different number of times each month...