LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
ew ew is offline
external usenet poster
 
Posts: 27
Default Sorting Issue

I am trying to sort three seperate arrays using the following code:

'Overhead broken down by site
'Denver
OVHsite.Range("E4").Copy
DataWks.Range("J28").PasteSpecial Paste:=xlValues
'Coastal
OVHsite.Range("O4").Copy
DataWks.Range("K28").PasteSpecial Paste:=xlValues
'Orem
OVHsite.Range("J4").Copy
DataWks.Range("L28").PasteSpecial Paste:=xlValues
'Overhead broken down by exception
'Denver
OVHsite.Range("D7:D13").Copy
DataWks.Range("N4").PasteSpecial Paste:=xlValues
'Coastal
OVHsite.Range("N7:N13").Copy
DataWks.Range("P4").PasteSpecial Paste:=xlValues
'Orem
OVHsite.Range("I7:I13").Copy
DataWks.Range("R4").PasteSpecial Paste:=xlValues
'Sort Ovh
DataWks.Range("N4:O10").sort Key1:=Range("N4"), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
DataWks.Range("P4:Q10").sort Key1:=Range("P4"), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
DataWks.Range("R4:S10").sort Key1:=Range("R4"), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

I am receiving the following error:

Run-time error '1004':
The sort reference is not valid. Make sure that it's within the data you
want to sort, and the first Sort By box isn't the same or blank.

What am I doing wrong? Any help would be appriciated....Thanks!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting issue Dr. Schwartz[_2_] Excel Discussion (Misc queries) 2 January 29th 08 03:39 PM
Sorting issue Sige Excel Programming 13 February 10th 06 03:19 PM
Sorting Issue. Please help V-ger Excel Discussion (Misc queries) 17 November 15th 05 12:27 AM
sorting issue steve Excel Discussion (Misc queries) 4 June 22nd 05 06:28 PM
sorting issue - help gennario Excel Discussion (Misc queries) 0 February 28th 05 05:27 PM


All times are GMT +1. The time now is 03:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"