Previous Topic Next Topic

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

Answer 1 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 27, 2016 at 11:04 AM
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
0
Answer 2 / 2
adikademani
Oct 27, 2016 at 01:59 PM
thanks a lott trowaD :)
0

Similar discussions

Excel Macro - Set and autofill a range?
KT -
excel987 -

28 responses
Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses
Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses