Member Avatar for Broxy
Broxy 0 Newbie Poster

Hi There

In an Excel Macro.
I am trying to install a manual Page break in an IF Statement, if it results in a 'Yes'.
What I am missing?
Please help. Best regards, Broxy.

Sub PM3()
'
' PM3 Macro
'
ActiveCell.FormulaR1C1 = "=IF(RC[1]=""yes"",

ActiveCell.ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell)"

End Sub

  • 1 Contributor
  • 0 Replies
  • 60 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.