New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

UsedRange Property

Macros, VBA, Excel Automation, etc.

UsedRange Property

Postby eli_cherry » Wed Feb 17, 2016 6:34 pm

I would like to display Range used with MsgBox
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??
  • 0

eli_cherry
Rookie
 
Posts: 1
Joined: Feb 17, 2016
Reputation: 0
Excel Version: 2013

Return to Macros and VBA Questions

Who is online

Users browsing this forum: Google [Bot] and 39 guests