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,

 

[VoG]

You should not need to loop

Sheets("Output").Range("A1").Resize(lstrow).Value = Sheets("Site2").Range("A1").Resize(lstrow).Value

 

[brulet]

You should not need to loop

Sheets("Output").Range("A1").Resize(lstrow).Value = Sheets("Site2").Range("A1").Resize(lstrow).Value

It still gives me expected array. I was using a loop, because I was calculating something in the next column, as the first column was filled.

Thanks again,

BT

<code>
sheets("Output").Range("A1").Resize(lstrow).Value = sheets("Site2").Range("A1").Resize(lstrow).Value
For i = 0 To (lstrw)
monthWorkingIn = month(sheets("Output").Range("A1").Offset(i, 0))
sheets("Output").Range("B1").Offset(i, 0) = interpolate(sheets("Site2").Range("B1").Offset(i, 0), Worksheets("Site2.Frequency." & month).Range("G2:G16"), Worksheets("Site2.Frequency." & month).Range("F2:F16"))
Next i
</code>

 

[VoG]

What is interpolate? Which line of code gives the error?

 

[brulet]

What is interpolate? Which line of code gives the error?

Still the same line

"sheets("Output").Range("A1").Resize(lstrow).Value = sheets("Site2").Range("A1").Resize(lstrow).Value"

I can comment out the interpolation with no effect. Interpolate is a custom function to log interpolate. It works, as I use it with a test function without a problem.

 

[VoG]

This works fine for me

Sub test()
Dim lstrow As Long
lstrow = Sheets("Site2").Range("A" & Rows.Count).End(xlUp).Row
Sheets("Output").Range("A1").Resize(lstrow).Value = Sheets("Site2").Range("A1").Resize(lstrow).Value
End Sub

 

[RoryA]

What is lstRw? Is it a function?

 

[brulet]

Sorry

<code>
lstrw = .Range("A" & Rows.Count).End(xlUp).Row
</code>

 

[RoryA]

And how is i declared?

 

[brulet]

i is declared in the for statement, is it not? I'm somewhat new to vba.