Hi guys,

I have a sheet which periodically through the day takes a snapshot of
financial prices.

This works fine as long as this is the active sheet, if it isn't I get a
vba error.

I've been using a laptop as a spare standalone machine for this sheet, as I
need to be using excel throughout the same period.

Can I make the code focus to the actual workbook that contains the code and
do what it needs to do in the background?

I'm thinking along the lines of ThisWorkbook.sheets("import").range("m3")
etc, which I'm hoping will do the job?

Will this do it?

Ron