Autofill numeration in row until last empty cell

[MaciejOlb]

Hi,
How can I create macro which can autofill numeration in row.
It have to end this macro at the end of this table.
I was trying to make it in this way:

Sub formuly_cena_zakupu_dziala()
'
' formuly_cena_zakupu Makro
'

'
Range("J18").AUTOFILL Range("J18:J" & Cells(Rows.Count, "J").End(xlUp).Row), Type:=xlFillSeries




End Sub

It worked perfect, but in empty sheet.
In my main sheet I got an error 1004 because of merged cells size.


Crossposted here: https://www.mrexcel.com/board/thread...-cell.1231254/