Maybe

Set gml = Sheets("Input").Range(Cells(1, 13), Cells(5, 15))

Mike

"cgnotrom" wrote:

Don't know why this code won't work
Trying to define array ("M1:O1") thru ("M5:O5")
and input results to a child sheet
The code below this and before the 'NEXT' statement works fine.

For g = 1 to 5
Set gml = Sheets("Input").Range(cells(g,13),cells(g,15))
next

Anyhelp is appreciated
Chris