View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Find value with the help of macro.

Share what your code is so far.

Heera wrote:

My problem is this.

I have two workbooks.

In 1st workbook there is a value.

My macro should go to the 2nd workbook and find the value of 1st
workbook on which my cursor is.

for example 1st workbooks has a value 50K in C6 cell
then My macro should go in 2nd workbook and find 50K in selected
range.
then again it should come back to the C6 cell of 1st workbook.

Again the same loop for the cell value which is there in C7.

I recoreded a Macro of (ctrl+f ) but it is giving an error.

Regards

Heera


--

Dave Peterson