Surely, if you are competent enough to ask a question that specific and that
accurate (in terms of OM and syntax), you are competent enough to try and
find out yourself?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ron" wrote in message
10.205...
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