Now I understand about Sendkeys and see how they could be useful in this
situation, but how/where do I record one and integrate it into my macro?

"Naz" wrote:

Hi there,

Look up Sendkeys in the visual basic editor help.

Hope that helps

Naz,
London

"Beancounter" wrote:

I want to program an Excel macro to set a columnar range, then perform the
keystroke series "F2, Home, =, Enter" repeatedly until the end of the range
is reached. How do I teach the macro to automatically repeat the keystoke
series? I am using XP, and Excel 2002 10.4. Thanks for your help!!!