iI have a Workbook which has about 7 sheet in it. I have created a macro which reformats cells in the spreadsheet. The problem is the range is different in each sheet. Basically the macro either needs to be tailored for each spreadsheet or intelligent to detect what spreadsheet it is and apply the appropriate range.
Has anyone got a easy solution to my problem?
Can macro be attached to individual spreadsheet in a workbook?
Has anyone got a easy solution to my problem?
Can macro be attached to individual spreadsheet in a workbook?