Hi sarah,
If I understand correctly, if you want to look at the 10th column to the right of the active cell, try this :
![]()
LastCol = ActiveCell.Offset(0, 10).Column
Hi sarah,
If I understand correctly, if you want to look at the 10th column to the right of the active cell, try this :
![]()
LastCol = ActiveCell.Offset(0, 10).Column
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks