This topic has not yet been rated - Rate this topic

Sheets.FillAcrossSheets Method

Office 2003

Copies a range to the same area on all other worksheets in a collection.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll)

Copy

'Usage
Dim Range As Range
Dim Type As XlFillWith
Dim sheets1 As Sheets
sheets1.FillAcrossSheets(Range, Type)

Copy

void FillAcrossSheets(
	[In] Range Range, 
	[In, Optional] XlFillWith Type
);

Copy

public void FillAcrossSheets(
	/*in*/Range Range, 
	/*in*/XlFillWith Type
);

Copy

function FillAcrossSheets(
	 Range : Range, 
	 Type : XlFillWith
);

Range: Required Range object. The range to fill on all the worksheets in the collection. The range must be from a worksheet within the collection.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ