Using VBA how would I get the sheet name of a range? or how do I grab the sheetname I'm leaving when I do a Worksheet_Deactivate()?
What I want to do is resize a range on sheet X when I do a Worksheet_Deactivate() on sheet X. I can do this no problem when I know the name of sheet X but the end user may change the sheet name.
What I want to do is resize a range on sheet X when I do a Worksheet_Deactivate() on sheet X. I can do this no problem when I know the name of sheet X but the end user may change the sheet name.