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
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
Hi,
ActiveCell is a range already so you do not require the Range property there. Use just
Indeed you can reduce the code to merely thisfeat_ure = ActiveCell.Value
Dim feat_ure As String feat_ure = ActiveCell.Offset(0, 1).Value
Don
Please remember to mark your thread 'Solved' when appropriate.
thanks a lott xlnitwit
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks