Posted to microsoft.public.excel.programming

Ayo

external usenet poster

Posts: 489

Help with SORT property in xl2007 and xl2007 !!!!!!!!!!!!!!!!!!!!

I have this line of code in my macro. Someone with Excel 2003 can go past it.

BOReportWS.Sort.SortFields.Clear

Is there a way to get it to run in xl2003?

'BOReportWS.Sort.SortFields.Add Key:=Range("A3:A" & BO_DownloadWS_lastRow)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
XL2007: Down < down on Enter?	GeoBrooks	Excel Discussion (Misc queries)	3	December 4th 09 04:00 PM
XL2007: Add my certificate?	Ed from AZ	Excel Programming	0	September 23rd 09 04:12 PM
Guidance, please (xl2007)	Kragelund	Excel Programming	5	December 8th 08 08:28 PM
xl2007	Nigel[_2_]	Excel Programming	5	October 12th 07 12:28 AM
Max row Height in XL2007	Billy Liddel	Excel Discussion (Misc queries)	1	May 19th 07 11:56 AM

All times are GMT +1. The time now is 05:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us