Danny's VBA Scripts

Name

Returns

Description

Read-only. Returns a collection holding all the horizontal page breaks associated with the Worksheets collection

Visible

Variant

Set/Get whether the worksheets in the collection are visible. Also can set this to xlVeryHidden to prevent a user from making the worksheets in the collection visible

VpageBreaks

VPage Breaks

Read-only. Returns a collection holding all the vertical page breaks associated with the Worksheets collection

Add

Method. Parameters: [Before], [After], [Count], [Type] . Adds a worksheet to the collection. You can specify where the worksheet goes by choosing which sheet object will be before the new worksheet object (Before parameter) or after the new worksheet (After parameter). The Count parameter decides how many worksheets are created

Copy

Method. Parameters: [Before] , [After] . Adds a new copy of the currently active worksheet to the position specified by the Before or After parameters

Delete

Method. Deletes all the worksheets in the collection

FillAcross Sheets

Method. Parameters: Range As Range, Type. Copies the range specified by the Range parameter across all the other worksheets in the collection. Use the Type parameter to pick what part of the range is copied (for example, xlFillWithContents, xlFillWithFormulas)

Move

Method. Parameters: [Before],[After]. Moves the current worksheet to the position specified by the parameters

Printout

Method. Parameters: [From], [To], [Copies], [Preview], [ActivePrinter], [PrintToFile], [Collate, [ [PrToFileName], [IgnorePrintAreas]. Prints the worksheets in the collection. The printer, number of copies, collation, and whether a print preview is desired can be specified with the parameters. Also, the sheets can be printed to a file using the PrintToFile and PrToFileName parameters. The From and To parameters can be used to specify the range of printed pages

Name

Returns

Description

PrintPreview

Method. Parameters: [EnableChanges]. Displays the current worksheet in the collection in a print preview mode. Set the EnableChanges parameter to False to disable the Margins and Setup buttons, hence not allowing the viewer to modify the page setup

Select

Method. Parameters: [Replace]. Selects the current worksheet in the collection