I created a UDF in VBA to use in a workbook that takes the number of a sheet , e.g. Sheets(3) and returns the name of the sheet which is possible in VBA. The Sheets workbook function works in reverse fashion by returning the sheet number when supplied the name. I have a column of numbers and the next column uses these to list the worksheets by name corresponding to the values in the previous column. However if I rename a sheet, and I do this with VBA macros when appropriate to my application, the UDF in the aforementioned column on the worksheet does not automatically refresh. How can this be accomplished? Can I do a Range.calculate or something like that in VBA?
Bookmarks