Dear Mr Excel, i´d like know how i can the following Macro:
In the A colum i have numbers for the days for one month (1 to 31)
In another cell i have a formula to obtain the number of the day ( i.e. Sep 4=4)
The macro munt go to the cell in A colum that contain the number in the formula.
I tryed with go to, find, but in the macro don´nt change the number to locate.
Thanks in advance
In the A colum i have numbers for the days for one month (1 to 31)
In another cell i have a formula to obtain the number of the day ( i.e. Sep 4=4)
The macro munt go to the cell in A colum that contain the number in the formula.
I tryed with go to, find, but in the macro don´nt change the number to locate.
Thanks in advance