M
Minitman
Greetings,
Is there anyway to press F2 inside of a macro with vba???
I can get my code to work if I manually press F2 after I hit enter.
But when I try to record it to see how vba interprets my keystrokes,
all it shows is this:
Range("AN5:AY5").Select
ActiveCell.FormulaR1C1 = "9/19/1981"
Range("BL5:BW5").Select
ActiveCell.FormulaR1C1 = ""
I hit Enter then F2. I did this twice in the sample above and this is
what gets recorded. In the first cell was a date and the second cell
was empty. I don't need to be copying or pasting over what is already
in the cell, I just need the ability to do so if needed.
Anyone have any ideas as to how to do this with vba?
Any help is always appreciated.
-Minitman
Is there anyway to press F2 inside of a macro with vba???
I can get my code to work if I manually press F2 after I hit enter.
But when I try to record it to see how vba interprets my keystrokes,
all it shows is this:
Range("AN5:AY5").Select
ActiveCell.FormulaR1C1 = "9/19/1981"
Range("BL5:BW5").Select
ActiveCell.FormulaR1C1 = ""
I hit Enter then F2. I did this twice in the sample above and this is
what gets recorded. In the first cell was a date and the second cell
was empty. I don't need to be copying or pasting over what is already
in the cell, I just need the ability to do so if needed.
Anyone have any ideas as to how to do this with vba?
Any help is always appreciated.
-Minitman