Error "Range of object Global failed"

**AdiK** · 10-27-2016, 03:55 AM

Hello Everyone,

Kindly check my code for mistakes. I am getting an error in this part of my code as "range of Object _Global failed".

Dim feat_ure As String
ActiveCell.Offset(0, 1).Activate

feat_ure = Range(ActiveCell).Value

Thanks in advance

**xlnitwit** · 10-27-2016, 04:12 AM

Hi,

ActiveCell is a range already so you do not require the Range property there. Use just

Please Login or Register  to view this content.

Indeed you can reduce the code to merely this

Please Login or Register  to view this content.

**AdiK** · 10-27-2016, 02:01 PM

thanks a lott xlnitwit

Error "Range of object Global failed"

LinkBack

Thread Tools

Rate This Thread

Display

Error "Range of object Global failed"

Re: Error "Range of object Global failed"

Re: Error "Range of object Global failed"

Thread Information

Users Browsing this Thread

Similar Threads

"Method ‘Range’ of object ‘_Worksheet’ failed" error message in Excel/PowerPoint VBA

[SOLVED] Receiving a "Method 'Range' of object'_Global' failed" error

Getting "..object _worksheet failed..." error with intersect for cell and named range.

XL03 Sort error: "Method 'Range' of object '_Worksheet' failed"

"Method 'Range' of object '_Worksheet' failed" error in Windows Script Host

Error: "Method 'Range' of object '_Global' failed"

[SOLVED] "GoalSeek method of Range object failed" error message

Bookmarks

Bookmarks

Posting Permissions