Locked Datavalidation change range then copy?? how?

[mkh12ab]

Hello everyone,

i am having an confusing issue here?

i will copy a dynamic range there:
Column A = text
Column B = dropdown list with $$ to lock the values then i copy

all dropdown have been made the same way and are locked from row 3$ to row 100$
then i copy the dynamic range 1 cell changes from row 3$ to row 4$?

the original area which i copy from stays the same with row 3$ locked
all the other dropdowns are locked as they are supposted to..

any1 know how this can be? and any solution on how to solve it??


below you can see the VBA (however the macro doesnt seems to be the issue)

Sub TilføjAgregat()

'Denne macro kopiere et nyt aggregat inde på forsiden

Application.ScreenUpdating = False

Dim irow As Long
Dim sht As Worksheet
Set sht = Ark2

Ark1.Activate
Range("A1").End(xlDown).Select
ActiveCell.Offset(1, 0).Select

irow = sht.Cells(sht.Rows.Count, 1).End(xlUp).Row
sht.Range("A1:B" & irow).Copy

Ark1.Activate
ActiveCell.PasteSpecial


Application.ScreenUpdating = True

End Sub