Range("B2").Select
ActiveCell.FormulaR1C1 = "=Released! /Range("B3").Select/ Selection.End(xlDown).Select"
Sorry this is so abstract, but I would like to combine these to set a specific cell equal to a cell that will always fall at the end of a column(which will tend to be different lengths).
ActiveCell.FormulaR1C1 = "=Released! /Range("B3").Select/ Selection.End(xlDown).Select"
Sorry this is so abstract, but I would like to combine these to set a specific cell equal to a cell that will always fall at the end of a column(which will tend to be different lengths).