Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to control two workbook
Hello,
I have a file with 3 worksheets. I assigned a macro to a combo box on sheet1. The macro only controls sheet2. How can I modify this macro so it works for both sheet2 and sheet3? Sheet2 and sheet3 are identical. Sub RwHide() Dim RwCnt As Integer For RwCnt = 8 To 138 If Range("N" & RwCnt) = 0 Then Range("N" & RwCnt).EntireRow.Hidden = True End If Next For RwCnt = 8 To 138 If Range("N" & RwCnt) < 0 Then Range("N" & RwCnt).EntireRow.Hidden = False End If Next End Sub Thanks a lot, LLee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transferring control from macro in one workbook to macro in anothe | Excel Programming | |||
Can I pass control to a 2nd workbook | Excel Programming | |||
ActiveX Control with workbook | Excel Programming | |||
Giving Macro control to another workbook | Excel Programming | |||
Workbook Permissions - How to Control? | Excel Discussion (Misc queries) |