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

Closed
prashanth - 31 Oct 2015 à 04:26
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 Nov 2015 à 12:20
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


Related:

1 response

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