Hi Laughing Gravy,

Try posting your problematic code.

However, you can almost certainly resolve your
problem by explicitly qualifying your ranges.


---
Regards,
Norman

"laughing gravy" wrote in message
...
Hi

I've dropped a commandbutton onto a work book. The button collects data
from
that work book when clicked and opens a different workbook to apply the
data
collected on to the new workbook. Alls good until I program a range/cell I
want the data dumped into when I get an error 1004 message. The program
still
seems to be pointing at the first workbook. Any ideas how I get it to
focus
on the new workbook?