Error "Range of object Global failed" [Solved/Closed]

Report
Posts
6
Registration date
Monday October 24, 2016
Status
Member
Last seen
November 24, 2016
-
 adikademani -
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

2 replies

Posts
2599
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
March 24, 2020
401
Hi adikademani,

ActiveCell is already a range so change:
feat_ure = Range(ActiveCell).Value

into:
feat_ure = ActiveCell.Value

Or use:
feat_ure = ActiveCell.Offset(0, 1).Value

Best regards,
Trowa
thanks a lott trowaD :)