Thread: If ActiveSheet = .. then - I get an error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eager2Learn[_4_] Eager2Learn[_4_] is offline
external usenet poster
  
Posts: 1
Default 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 QuoteReply With Quote