PDA

View Full Version : runtime error 13???



enfantter
11-29-2007, 01:40 AM
Hey all,
maybe this relates to an earlier thread or recent updates, but i get this runtime error when i try to push the button labelled "DanskeKriterie" in the sheet "struktur".

Until now it has been working perfectly so i really hope any of you se the obvious soloution to this problem??!

enfantter
11-29-2007, 01:42 AM
here is the sheet

rory
11-29-2007, 03:07 AM
Change the first bit of your userform's Initialize routine to this:
With Sheets("Indtastning af ny opgave")
Set Rng1 = .Range(.Cells(3, 1), .Range("A" & Rows.Count).End(xlUp))
End With

Note: You should also change your rng2, rng3 and rng4 assignments to use similar syntax.