additional info: To use the FillAcrossSheets method, you would have to set
an array for the sheets you want to include in the action, or specify all the
sheets like this:

Workbooks(1).Sheets.FillAcrossSheets Sheets(1).Range("B2").CurrentRegion

You could then add the constant xlFillWithContents if need be.

"cgnotrom" wrote:

Using 2007 Excell and trying to send data to a child sheet
Currently I am getting the Formula and Colors and Borders.
I only want the Value result of the formula to be copyed to the next sheet,
not the Formula.

example of a command I am using;

Set lg = Sheets("mine").Cells(6,13).Resize(1,3)

tryed to enter the statement Type:=xlFillWithContents
but the debugger didn't like me.
Please help !