Hi -

I am automating some plan data that we have and seem to be running into a
problem using paste special to copy data from one spreadsheet to another. Is
there any restriction that dones not allow this? I have been able to
successfully write VBA code that copies and pastes the data that I need from
one spreadsheet to another - the only issue is that I would really rather
just past the values rather than the formulas as well (hence the need for
paste special). Does anyone have a simple example where they have gotten
this to work?

Thanks,
Meryl