Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can a function call another function? Here is the function I have. I am tring
to apply a page break (which works fine) then tring to call my format page funtion after it applies the page break?? Sub setPage() Dim iRow As Long Dim myCell As Range Dim myRng As Range Dim wks As Worksheet Dim searchFor As String searchFor = FrmCreate.CbxDept.Text Set wks = Worksheets(searchFor) With wks .ResetAllPageBreaks Set myRng = Nothing On Error Resume Next Set myRng = .Range("a1", .Cells(.Rows.Count, "A").End(xlUp)) On Error GoTo 0 If myRng Is Nothing Then MsgBox "No visible cells!" Exit Sub End If iRow = 0 For Each myCell In myRng.Cells iRow = iRow + 1 If iRow 1 Then If iRow Mod 19 = 1 Then .HPageBreaks.Add befo=myCell Call FormatHeaders End If End If Next myCell End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF function question | Excel Worksheet Functions | |||
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
Function Question | Excel Worksheet Functions | |||
Question Regarding Name Function | Excel Programming | |||
Help: Question Regarding Name Function | Excel Programming |