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