View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] esignups.eastland@gmail.com is offline
external usenet poster
 
Posts: 2
Default Easy code, confounded by error

I'm simply trying to get the text stored in a cell that has its own named range. I keep getting a "Method 'Range' of 'object _Global' failed" error. Here is the code:

Dim temp As String
temp = Range("statusBarMsg").Value2

What can I be missing here? Thanks.