I've set an object by using .find to identify a cell.
Set ACCTS_PAYABLE_OBJECT = Sheets(BAL_SHT_TAB_NAME).Range(TAG_RANGE).Find(SEARCH_STRING, LookIn:=xlValues, LookAt:=xlPart)
Is there a cleaner way to get the value of the cell in the next column to the right from the object cell?
Right now I'm using:
ACCTS_PAYABLE_VALUE = Worksheets(BAL_SHT_TAB_NAME).Cells(ACCTS_PAYABLE_OBJECT.Row, 2).Value
but I thought I had read something that gets the value more easily/directly but I can't find it now.
If anyone has an idea on this I would appreciate the help.
Set ACCTS_PAYABLE_OBJECT = Sheets(BAL_SHT_TAB_NAME).Range(TAG_RANGE).Find(SEARCH_STRING, LookIn:=xlValues, LookAt:=xlPart)
Is there a cleaner way to get the value of the cell in the next column to the right from the object cell?
Right now I'm using:
ACCTS_PAYABLE_VALUE = Worksheets(BAL_SHT_TAB_NAME).Cells(ACCTS_PAYABLE_OBJECT.Row, 2).Value
but I thought I had read something that gets the value more easily/directly but I can't find it now.
If anyone has an idea on this I would appreciate the help.