Report

Error "Range of object Global failed" [Solved]

Ask a question adikademani 6Posts Monday October 24, 2016Registration date November 24, 2016 Last seen - Last answered on Oct 27, 2016 01:59PM
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 
Helpful
+0
moins plus
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
Add comment
Helpful
+0
moins plus
thanks a lott trowaD :)
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!