Posted to microsoft.public.excel.programming

Eager2Learn[_4_] Eager2Learn[_4_] is offline

external usenet poster

Posts: 1

If ActiveSheet = .. then - I get an error

Hello,
I am getting an error with this simple code. Help.

Sub MainSort()
If ActiveSheet = Worksheets("1-OPEN") Then Call Sort
If ActiveSheet = Worksheets("Internal Transfers") Then Cal
SortStatus
MsgBox ("Sorry, sort not available")
End Sub

Help

--
Message posted from http://www.ExcelForum.com

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
ActiveSheet.Paste (error)	Puzzled	Excel Worksheet Functions	1	August 2nd 07 06:18 PM
ActiveSheet.Paste - Error help?	dk_	Excel Discussion (Misc queries)	4	November 20th 06 12:27 AM
help: Activesheet.save error with XL 2000	jasonsweeney[_50_]	Excel Programming	4	February 28th 04 06:48 PM
ActiveSheet.Paste error	Ron de Bruin	Excel Programming	0	July 25th 03 12:39 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us