Search this Forum
I have run time error 1004 when i try to setup shapefile.What can i do?
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).
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
Replied to in thread: http://www.statsilk.com/support/forum/map-appears-vertical-line