4 posts / 0 new
Last post
Run time error 1004

I have run time error 1004 when i try to setup shapefile.What can i do?

StatSilk's picture

This might be related to your other post about the vertical line? Would you be able to click on 'debug' and indicate the highlighted code (and if possible the row/column number which can be found in the top of the screen).

Many thanks,


This is the highlighted code:

Selection.Sort Key1:=Range(Cells(1, 2), Cells(ActiveSheet.UsedRange.Rows.Count, 2)), Order1:=xlAscending, Key2:=Range(Cells(1, 3), Cells(ActiveSheet.UsedRange.Rows.Count, 3)), Order2:=xlAscending, Header:=xlNo, Orientation:=xlTopToBottom

StatSilk's picture