Posted to microsoft.public.excel.misc

peyman

external usenet poster

Posts: 189

question on VB-sort

hi,
I see an error when I run the following code.the order focuses on "order"
poping up a message like"named argument not found"??any help?

Private Sub CommandButton16_Click()
Sheets("sheet1").Activate
Range("e95:g108").Sort key1:=Range("e95"), Order:=xlDescending
End Sub

thanx

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
Sort question??	SAM SEBAIHI	Excel Discussion (Misc queries)	0	November 29th 06 02:03 AM
sort question	D	Excel Worksheet Functions	0	August 2nd 06 10:08 PM
Sort question	pgruening	Excel Discussion (Misc queries)	0	May 18th 06 08:22 PM
sort question	Romi	Excel Discussion (Misc queries)	1	June 16th 05 11:25 PM
Lookup and Sort Question	Josh O.	Excel Discussion (Misc queries)	7	December 9th 04 08:18 PM

All times are GMT +1. The time now is 12:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us