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

adikademani 6 Posts Monday October 24, 2016Registration date November 24, 2016 Last seen - Oct 27, 2016 at 03:58 AM - Latest reply:  adikademani
- Oct 27, 2016 at 01:59 PM
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
See more 

2 replies

TrowaD 2396 Posts Sunday September 12, 2010Registration dateModeratorStatus July 19, 2018 Last seen - Oct 27, 2016 at 11:04 AM
0
Thank you
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
adikademani - Oct 27, 2016 at 01:59 PM
0
Thank you
thanks a lott trowaD :)