Can I put the [F2] Function in a macro?

[steve case]

After my macro runs, I would like to have the cursor ready to add
onto the cell contents just as if I pressed the [F2] function button.
Can this be done?

 

[VoG]

Try

SendKeys "{F2}"

 

[steve case]

Try

SendKeys "{F2}"

THANK YOU THANK YOU THANK YOU THANK YOU !

A free answer in in less than four minutes (-:

 

[steve case]

Most salty dogs are rum soaked
.
.
.
.
.
.
.
.
.
.

 

[VoG]

Most salty dogs are rum soaked

In my case Salty-dog doesn't refer to a sailor (Google it) and gin is definitely my preference (as Richard Schollar who created my subtitle knows).

Thanks for the feedback. In general SendKeys should be avoided (it is flaky) but I cannot see how this example would fail.

 

[cedricthecat]

In my case Salty-dog doesn't refer to a sailor (Google it) and gin is definitely my preference (as Richard Schollar who created my subtitle knows)..

Restaurant in Jersey, crisps "that bite back", ****tail of vodka and grapefruit juice, album by the Rock band Procol Harum...

Any of these? Come on Peter, I need to know!

 

[VoG]

A bloke who has been around a bit (i.e. ancient).

 

[cedricthecat]

A bloke who has been around a bit (i.e. ancient).

I'd prefer to think that you like crisps!