Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with code repair
How can I modify the code below to reference a non-active worksheet, I do not
want to use 'Activeworksheet' Dim dX As Double, dCount As Double Worksheets("test").Activate sSelected = Me.Cbo1.Value dCount = 0 If IsError(Application.Match(sSelected, ActiveSheet.Columns(1), 0)) Then frm1.Hide frm2.Show End If For dX = 1 To ActiveSheet.UsedRange.Rows.Count If Cells(dX, 1).Value = sSelected Then Me.Cbo2.AddItem Cells(dX, 2).Value dCount = dCount + 1 End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unknown repair | Excel Discussion (Misc queries) | |||
Looking For a repair tool | Excel Discussion (Misc queries) | |||
I need to repair an invalid hyperlink | Excel Worksheet Functions | |||
open & repair through vba | Excel Programming | |||
detect and repair vs regserver | Excel Programming |