0

Below is my code, each sheet has a different number of rows. How do I select the last values (last cells) from columns O so calculations work?

Range("O" + ActiveCell.Row + 1).Select
ActiveCell.FormulaR1C1 = "='Tier 1'!R[-1]C"
Range("O1").End(xlToRight).Column.Select
Application.CutCopyMode = False
TheKidLorry
  • 1
  • 1
  • First of all, `.Column` returns the column number, you can't `.Select` a column number. Second of all, use `Cells(1, Columns.Count).End(xlToLeft)` to get to the last used column. – BigBen May 26 '22 at 18:47

0 Answers0