Working with a worksheet that is not the active worksheet

Posted to microsoft.public.excel.programming

ordnance1[_2_] ordnance1[_2_] is offline

external usenet poster

Posts: 92

Working with a worksheet that is not the active worksheet

How can I make this code work on my worksheet named February, when it is not
the active worksheet?

Sub BlankWeeks()
'
' Macro2 Macro
'

'
If Range("C184").Value = "" Then
Rows("184:228").Hidden = True
End If

If Range("C184").Value < "" Then
Rows("184:228").Hidden = False
End If

If Range("C229").Value = "" Then
Rows("229:273").Hidden = True
End If

If Range("C229").Value < "" Then
Rows("229:273").Hidden = False
End If

End Sub

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
Copying the active worksheet to another worksheet in the same work	queenmaam	Excel Worksheet Functions	5	March 25th 08 06:56 PM
Deleting column in a worksheet that is not active worksheet	[email protected]	Excel Programming	3	October 7th 07 03:33 PM
Basic Question - How do I return the worksheet number of the active worksheet?	Regnab	Excel Programming	2	May 17th 06 03:02 AM
Altering code to reference the worksheet before the active worksheet	KimberlyC	Excel Programming	8	March 15th 05 10:26 PM
macro to apply worksheet event to active worksheet	Paul Simon[_2_]	Excel Programming	3	August 7th 03 02:50 AM

All times are GMT +1. The time now is 12:51 PM.

Menu

About Us