Error "Range of object Global failed"
Solved/Closed
adikademani
Posts
5
Registration date
Monday October 24, 2016
Status
Member
Last seen
November 24, 2016
-
Oct 27, 2016 at 03:58 AM
adikademani - Oct 27, 2016 at 01:59 PM
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
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:
- Error "Range of object Global failed"
- Object desktop - Download - Customization
- Counter strike global offensive download - Download - Shooters
- Convert picture to object in powerpoint - Guide
- Apple airtag range - Guide
- How to increase wifi range from router settings - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Oct 27, 2016 at 11:04 AM
Oct 27, 2016 at 11:04 AM
Hi adikademani,
ActiveCell is already a range so change:
into:
Or use:
Best regards,
Trowa
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
