EXCEL VBA copy row 1 to X rows down

[Dan Nielsen]

Hi

I have been using a large EXCEL sheet with a lot of VBA. But suddenly a line does not work.. (It has been working for a long time).

I get
Run-time error '1004':
Markeringen er for stor.
(The marked area is to big)

It works but only to 4000 rows, if there more i fails.

I have the same line working in a old version (with more then 6000 rows) of the file, but i have changes so much since

_______________________________________
Rem Udvid ark
Dim RowNo As Long
RowNo = Workbooks("LetOptik").Worksheets("FakturaLinje_DB").Range("A" & Rows.Count).End(xlUp).Offset(3).Row 'RowNo er blevet defineret i Modul1 "Option Explicit Public RowNo As Long"
If RowNo < 5 Then RowNo = 5


Workbooks("LetOptik").Worksheets("Salgsoversigt").Range("A5:BM5").AutoFill Destination:=Workbooks("LetOptik").Worksheets("Salgsoversigt").Range("A5:BM" & RowNo), Type:=xlFillDefault 'Kopier formler til resten af ark.
____________________________________________

 

[jmacleary]

Hi there. Have you checked what row number is actually being determined? It is possible that the row number is coming out much bigger than 4000. Put a 'msgbox RowNo' line in after your RowNo= statement (or a breakpoint in the VBA editor) and see what it shows.

 

[Dan Nielsen]

Yes i have checkede with msgbox.

 

[Joe4]

So, what value is the MsgBox returning for the RowNo value?
Do you have any merged or protected cells on your sheet?

 

[Dan Nielsen]

6224
Ny workaround is a Line Thats first Copy to rød no 4000 and then then The vba gode that chef total likes to Copy and Copy from row 4000. Og Worlds but When i have over 8000 roes again i Will have The problem

 

[Joe4]

You did not answer my second question.

 

[Dan Nielsen]

Jo there is not.
Everything Worlds ås long it is max 4000 rows

 

[Joe4]

Around the rows where the errors occur, is there any strange data, like maybe some formulas that are returning errors?
If not, it is going to be hard to figure out what might be going on without seeing the data and complete code you are working with.