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 ?HTML Code:
edit: it works if i use: Sheets("Number of open orders") instead, but i was certain i could refer to the sheet nr aswell ?
Bookmarks