Thank you JBeaucaire for taking the time to examine my macro, but I am still getting the same error even with your revised code:
the line that is problematic:
I thought that I had created a dynamic sheet so that any workbook that I open that need this particular type of formatting I could format without explicitly call/reference the name of the workbook, but instead would act on the first sheet in the workbook that needs this formating.
I had asked in this thread how to even set up the formula and thought that I had refenced the sheet as a dynamic sheet, but something is still wrong
I am using Excel 2007 on Windows XP
Bookmarks