how to refer to a sheet properly

[siggisigg]

I have a line of code, it used to work fine, but after some smaller changes, its not doing it what i want it to do.

it is meant to tkae the value from the second sheet in wb2, and paste it into the sheet data in WB. however it is actually gathering data from the first sheet. any suggestions why ?

edit: it works if i use: Sheets("Number of open orders") instead, but i was certain i could refer to the sheet nr aswell ?

[nathansav]

What have you set wb and wb2 to be?

[HaHoBe]

Hi, siggisigg,

me personally would prefer to fully qualifiy the name of the worksheet instead of using itīs position in a workbook as that may be different due to somebody dragging the sheet around. This one line of code out of the context looks good for me instead that I would add a .Value after the first part of the equation

wb.Sheets("Data").Range("H" & Rows.Count).End(xlUp).Offset(1, 0).Value = wb2.Sheets(2).Range("F10").Value

Edit: You maybe should use Worksheets instead of Sheets as Sheets may as well be a chart as a worksheet.

Ciao,
Holger

[siggisigg]

WB is the workbook im working in, WB2 is a chosen workbook to gather data from.

HaHoBe:
ah, ok. that might be the problem. i didnt realize it refered to the number according to when it was created. i rather thought it was what position it was in. that makes sence though. thanks!