more info needed. You do not need to goto the destination sheet. The basic
idea is
[destinationsheet!a1].value=[sourcesheet!a1].value

--
Don Guillett
SalesAid Software

"Rohith Kori" wrote in message
om...
Hi,

I have a problem in which I have to copy the values in a range of
cells ( this range is dynamic and decided at run time) from worksheet
1 to worksheet 3. Then the control must return to worksheet 1.


Any suggestions on how to do this would be highly appreciated.

Thanks and Happy New Year

Rohith Kori