Hi Akash,

'----------------
Based on your mail i viewed the site mentioned by you.

I tried to copy this code and tried to run it.

[...]
But it showing me error as Compiler Error: Sub or Function not
Defined.
Last = LastRow(DestSh)

What should i do in this regards.

Awaiting for a resolution from your end.

[...]
'----------------

If you look again at Ron's page, you will see:

'-----------------
Important: The macro examples use the functions that you
can find in the last section of this page.
'-----------------

Therefore, try copying the function LastRow into
your code module and then retry Ron's code.


---
Regards,
Norman