To retrieve the name of the sheet ws where your range "My_Range" is located, simply write:
ws = Range(My_Range).Parent.Name
Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD
Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com
No comments:
Post a Comment