I am receiving the "Application Defined or Object Defined Error" on line
The entire chunk is this:
The overall goal is to set an integer value corresponding to the column for the activecell
Code:
Selection.End(xlToRight).Offset(0, 1).Select
The entire chunk is this:
Code:
COM.Worksheets(AC).Activate Cells(j, 1).Offset(-1, 0).Select
Selection.End(xlToRight).Offset(0, 1).Select
b = ActiveCell.Column
The overall goal is to set an integer value corresponding to the column for the activecell