Error "Range of object Global failed"

Solved/Closed
adikademani Posts 5 Registration date Monday 24 October 2016 Status Member Last seen 24 November 2016 - 27 Oct 2016 à 03:58
 adikademani - 27 Oct 2016 à 13:59
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
Related:

2 responses

TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
27 Oct 2016 à 11:04
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
27 Oct 2016 à 13:59
thanks a lott trowaD :)