Expected Array

[brulet]

Is there a way to copy a value from one cell to another, without using select? Same workbook, different worksheet. This line is causing an error "Expected array". lstrw is the lastrow and is an int.

<code>
For i = 0 To (lstrw)
sheets("Output").Range("A1").Offset(i, 0).Value = sheets("Site2").Range("A1").Offset(i, 0).Value
Next i
End Sub

</code>

Thanks again,

 

[RoryA]

Not explicitly - do you have a Dim i statement (or Dim i() statement) anywhere in the code?

 

[brulet]

Not explicitly. I'll include it and let you know.
​

 

[brulet]

Still get the error.

BT

 

[VoG]

Try posting your complete code using code tags

[code]
your code here
[/code]