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

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Use marco recorder. Its available with excel
0