Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activesheet < Sheets("Name")
Hello guys, can I get some help with macros? I am trying to write a line that says If activesheet < Sheets("blahblah") then exit sub But of course, that didn't work. What should be the correct code? Also, sometimes when show the user an input box asking them to typ something then select OK or Cancel, when the users try to move the box the box doesn't refresh and their entire screen ends up with the shado of the box; like a trail of the message box. Is there a way t eliminate that? Thanks -- Etrnal16 ----------------------------------------------------------------------- Etrnal168's Profile: http://www.excelforum.com/member.php...fo&userid=2513 View this thread: http://www.excelforum.com/showthread.php?threadid=38700 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Count" and "List" functions across sheets | Excel Worksheet Functions | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
ActiveSheet.CircularReference.Address loses "Set" | Excel Discussion (Misc queries) | |||
Help Spreadsheet1.ActiveSheet.Range("B1").LoadText debugging | Charts and Charting in Excel | |||
How to change the ActiveSheet tab ("Plan1") | Excel Programming |