Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The routine below does not operate as intended, as the Call method
does not recognize a variable. Call Supported_Reports(i) does not work. How can I change this routine to male it work? Thanks! Sub Format_Reports() Dim Supported_Reports(1) As String Dim i As Integer Supported_Reports(0) = "CGE457" Supported_Reports(1) = "SPE962" For i = 0 To i = UBound(Supported_Reports) If Not ActiveSheet.Cells.Find(Supported_Reports(i)) Is Nothing Then Call Supported_Reports(i) Next i End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to call a private sub() in another module | Excel Programming | |||
IF Statements-call private sub | Excel Worksheet Functions | |||
private variable: same module, other Sub/Function | Excel Programming | |||
Initialize a Private variable | Excel Programming | |||
Call Private Function from ThisWorkbook module | Excel Programming |