- Code: Select all
Set myRange = ActiveSheet.UsedRange
MsgBox myRange
But this returns me error, I have solved the problem using
- Code: Select all
Set myRange = ActiveSheet.UsedRange
MsgBox myRange.Addres
My question is why I have to use addres??
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
Set myRange = ActiveSheet.UsedRange
MsgBox myRange
Set myRange = ActiveSheet.UsedRange
MsgBox myRange.Addres
Return to Macros and VBA Questions
Users browsing this forum: Majestic-12 [Bot] and 63 guests