Reference a cell in VBA

[klatlap]

Hi, i have an issue, this code is kind of working the problem is that in column K i have formulas that will only display data when the formula is correct, the problem is when the code runs it paste the items offset to the last formula, can i get it to paste offset to the last value instead?

Sheets("Sheet1").Range("K" & Rows.Count).End(xlUp).Offset(1, Sheets("Sheet1").Range("M1").Value).Resize(10, 1).Value = Sheets("Sheet1").Range("G3:G12").Value

 

[MARK858]

Try changing

Range("K" & Rows.Count).End(xlUp)

to

Columns(11).Find("*", , xlValues, , xlByRows, xlPrevious)

 

[klatlap]

Try changing

Range("K" & Rows.Count).End(xlUp)

to

Columns(11).Find("*", , xlValues, , xlByRows, xlPrevious)

Perfect, cheers