Hey,

I've recorded this macro that requires me to fill down functions to the last row with data. Instead of adjusting the Macro manually to fit the data set, is there something I can insert in this code to make the range "B2:F35" automatically change to "B2:F'last row'"?

I was also trying to have a text box pop up and ask for the number of rows I wanted to work with, but I wasn't successful there.

 Range("B2").Select
    ActiveCell.FormulaR1C1 = "=ROUNDDOWN(ABS(FactSet!RC-Varasto!RC),3)"
    Range("B2:F2").Select
    Selection.FillRight
'How many rows down below
    Range("B2:F35").Select
    Selection.FillDown
    Range("H1").Select
Any help is appreciated and thanks in advance.