How to create a macro to find the value in specified cell

Closed
prashanth - Oct 31, 2015 at 04:26 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 3, 2015 at 12:20 PM
Hello,

i need to create a macro to find a cell based on the value of other cell.
for e.g. i want find the cell by copying cell "DH1" (in which there is a formula say - "Today()" and it changes every day) and open search box ('Ctrl' + 'F') and paste it there and then click "Find next" then close the search box.

Can you please help me how to record a macro to do this task


1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 3, 2015 at 12:20 PM
Use marco recorder. Its available with excel
0