Hi guys,
I'm trying to reference the values from column F and put it into column Y. This is the code I have:
Range("Y22:Y" & Cells(Rows.Count, "F").End(xlUp).Row).Formula = "=F22"
My problem is that this formula can handle columns that end at various rows but it isn't dynamic for the start of the row. The start is hard coded at Y22 which links to F22 and the row above it (F21) is text which I want to ignore.
help me make this more dynamic so it doesn't matter where the first and last data points are in a column
thanks