Error "Range of object Global failed" Solved/Closed

Question

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

TrowaD · Answer

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 · Answer

thanks a lott trowaD :)

Error "Range of object Global failed"

2 responses

Similar discussions

Subscribe To Our Newsletter!