When user clicks on a particular cell in 1st work book, I want macro to go to next workbook and find for text and then select the cell in next workbook .
Can anybody help me regarding this????
Thanx
Prajakta
When user clicks on a particular cell in 1st work book, I want macro to go to next workbook and find for text and then select the cell in next workbook .
Can anybody help me regarding this????
Thanx
Prajakta
Hi Prajakta
Welcome to ozgrid.com
In order for someone to help, you will need to be more specific.
What defines "the next workbook"?
Is the "the next workbook" open?
What does "find for text" mean?
Hi,
I'm not sure but I think you want to do the same as in this thread, take a look at it.
http://www.ozgrid.com/forum/showthread.php?t=22259
Gollem
Don’t have an account yet? Register yourself now and be a part of our community!