Search this Forum
I have run time error 1004 when i try to setup shapefile.What can i do?
Hi, 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,
Frank
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
Hi,
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,
Frank
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