Re: Page Break????????

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Try...
ActiveSheet.Columns("S").PageBreak = xlPageBreakManual
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins: sorting, comparing, matching, listing, finding...)



"Kiba" <Kiba@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message
So I need to set a vertical page break and this is the macro I'm running but
it errors at this line.

Set ActiveSheet.VPageBreaks(1).Location = Range("S1")

Here's the full macro
_______________________________________________________________
Sub Test()
Set ActiveSheet.VPageBreaks(1).Location = Range("S1")
-snip-
End Sub

.

Relevant Pages

  • Re: Overhead caused by LE options with (XREF, MAP, LET)
    ... open code, does not HLASM also show you in the listing what it actually ... Overhead caused by LE options with (XREF, MAP, LET) ... making a reference that did not appear in the macro invocation. ...
    (bit.listserv.ibm-main)
  • Re: comparing doubles for equality
    ... Any problems using it in a macro? ... Do the same issues involved in comparing 2 fp types for equality ... apply to comparing a float to zero? ... highly dependent on external issues, ...
    (comp.lang.c)
  • Re: Comparing fp types for equality
    ... Do the same issues involved in comparing 2 fp types for equality ... The macro normalizes the difference between scalar a and scalar b regarding ...
    (comp.lang.c)
  • Re: Maddening Dilemma - Compare each cell within column a to each cell
    ... have matching reversal codes. ... Having the macro in its own file and having it run directly within my ... That is a very interesting suggestion with the date sorting and making ... The sort can remain, i can always autofilter and sort later ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Comparing fp types for equality
    ... Do the same issues involved in comparing 2 fp types for equality ... The macro normalizes the difference between scalar a and scalar b regarding ...
    (comp.lang.c)