excel vba sort range error 1004 De Lancey New York

Computer ServicesSystem SetupsComputer RepairHome and Small Business NetworkingHardware TroubleshootingSoftware TroubleshootingVirus Removal, PC Clean UpBasic Data Restoration Website ServicesJoomlaDrupalWordpressPHP and MySQLHTML and CSSXMLJavascript

Computer ServicesSystem SetupsComputer RepairHome and Small Business NetworkingHardware TroubleshootingSoftware TroubleshootingVirus Removal, PC Clean UpBasic Data Restoration Website ServicesJoomlaDrupalWordpressPHP and MySQLHTML and CSSXMLJavascript

Address 746 Main St, Margaretville, NY 12455
Phone (845) 586-6263
Website Link http://fairtekservices.com
Hours

excel vba sort range error 1004 De Lancey, New York

same code seems to be behaving differently at different times.. Ozgrid Retains the Rights to ALL Posts and Threads Register Help Remember Me? This riddle could be extremely useful How to get this substring on bash script? I never have used a Sort object like your doing, but I can see that you have not defined a key, or a range to sort by, just the range to

To start viewing messages, select the forum that you want to visit from the selection below. Following your explanation I have to agreewith your statement"at best pointless and inefficient, and at worst will produce incorrect results due to the quirks of the Evaluate method". Show Ignored Content As Seen On Welcome to Tech Support Guy! Works fine now. –Petethefeet Feb 22 '13 at 14:43 add a comment| up vote 0 down vote ...

I went oldschool and wrote the macro like in Excel 2000 and ran it in Excel 2010 with no problem: Sub fixsortoldschool() ThisWorkbook.Worksheets("PistonTest").Range("A1:GU6025").Select Selection.Sort Key1:=Range("E1"), Order1:=xlAscending, Key2:=Range("GR1") _ Promoted by Recorded Future Threat intelligence is often discussed, but rarely understood. Regards, Batman. MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Ask a Question Ask

Last edited by gnesterenko; Jul 6th, 2009 at 09:09 AM. rs IS a range object already. In my opinion the questionable row is only: ws.Sort.SetRange Range(rs) Here the Cells wich will be sorted are defined as a range. Make sure that there is private / sensitive data in it.

I havent a clue how to resolve this. Environment: WIN XP Pro 2002 Excel 2007 12.0.6425.1000 SP 3 VB 6.5 Version 1053 VBS retail 6.5.1053 Regards chris Edited by Chris227 Friday, January 14, 2011 12:47 AM for correctness its Near Earth vs Newtonian gravitational potential Can Communism become a stable economic strategy? I saw this clear-Methode before, but I didn't give it a chance. :) However your answer convinced me to check it out. –user2405095 Apr 28 '15 at 6:24 I

Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote May 9th, 2007,08:09 AM #4 avendesora New Member Join Date May 2007 Posts 8 here is the code Private Make sure it's within the data you want to sort, and the first Sort By box isn't the same or blank." This is the code 'Sort the active rows With ActiveWorkbook.Worksheets("Product Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve… MS Applications MS Office MS Excel Office Suites-Other Office / Productivity Creating a Scrolling Chart in Excel Video by: How should I interpret "English is poor" review when I used a language check service before submission?

it's a modern post apocalyptic magical dystopia with Unicorns and Gryphons How do you say "root beer"? What I mean is that your sort range will be between Column A and Column N (13 columns after A), but your criteria are in Columns R & S. It sorted fine. Featured Post What Is Threat Intelligence?

Last edited by corkyo4; October 25th, 2006 at 22:42. Then I did the same steps in recording a macro of me sorting them on 2 different columns, one ASC and the other DESC. MS Excel Advertise Here 769 members asked questions and received personalized solutions in the past 7 days. Sub sort_case_1() Dim ws As Worksheet Dim SortRange As Range Dim LastRow As Long Set ws = ThisWorkbook.Worksheets(1) With ws LastRow = .Range("A" & Rows.Count).End(xlUp).Row Set SortRange = .Rows("1:"

Charles Excel MVP The Excel Calculation Site http://www.decisionmodels.com/ Saturday, January 08, 2011 10:53 PM Reply | Quote 0 Sign in to vote Thanks Charles for the explanation of the square brackets. Why does argv include the program name? ws.Sort.SetRange rs I believe that my explanation is correct regardingwhy the OP's use of Range in the code causes an error. How to handle a senior developer diva who seems unaware that his skills are obsolete?

Maybe it's something you're overlooking and we could spot it... In your particular example case Evaluate will produce correct results but is unnecessary and inefficient. dataoption1 is not a good parameter in excel 2000 i do my best to test code works before i post it, but sometimes am unable to do so for some reason, In the OP's case this will only work if the used range starts in A1: at best this is redundant, at worst incorrect.

How should I interpret "English is poor" review when I used a language check service before submission? Results 1 to 12 of 12 Thread: Excel VBA Sort Help Error 1004 Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch What are "desires of the flesh"? Loading...

Reply With Quote Jan 12th, 2008,02:21 PM #11 anhn View Profile View Forum Posts Head Hunted Join Date Aug 2007 Location Australia Posts 3,669 Re: Excel VBA Sort Help Error 1004 If you extend your sort range, all will work. Are there any rules or guidelines about designing a flag? rs IS a range object already.

What does a well diversified self-managed investment portfolio look like? I've attached both files, if you want to run it you'll have to change the folder reference to the csv file. It is the the third worksheet but it auto named itself as Sheet2. I wil figure this out at work on monday, in my example the sort field range was identical to the usedrange which might have hide the problem, i have to add

Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next dim all variables as required Everything works fine, but after approximately 30 times I get an error 1004. CONTINUE READING Suggested Solutions Title # Comments Views Activity Microsoft Excel Digital Signature 2 30 17d Ctrl F does not find cells with formula 3 15 16d Incorporating a number range, Is "halfly" a word?

Why is absolute zero unattainable? House of Santa Claus more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation You may want to see THIS Do not use xlDown to construct your range.

I tried finding out what object it was but couldnt assign it to anything from code. After restarting Excel it is working which could be because the other sheets were closed but not reopened after you restarted Excel. –nhee Apr 27 '15 at 13:37 | show 4 Known limitations of Evaluate are documented under the section for Evaluate on the web-page http://www.decisionmodels.com/calcsecretsh.htm Charles Excel MVP The Excel Calculation Site http://www.decisionmodels.com/ Sunday, January 09, 2011 4:34 PM Reply |