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.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Autofill numeration in row until last empty cell
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[MaciejOlb]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Autofill numeration in row until last empty cell
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Ok. I don't know how to delete a post in excellforum. If you can delete it, please do it for me.

 

[Fluff]

There is no need to delete posts, just let us know if you do it in future.