How to run auto press 'Enter' key on certain cell before printing?

Please, help me. How to auto press Enter Key before printing from VBA. When the print button clicked, auto press Enter key run then printout. And auto press runs before next loop.

I think what you need is:

Formula:

Please Login or Register  to view this content.

Try a forum search on SendKeys to find out more information.

BSB

How to run
Application.SendKeys "{F2}"
Application.SendKeys "{ENTER}"
on range C1?

This code would perform that. Amend the sheet name to suit.

Please Login or Register  to view this content.

What is it you're actually trying to do? There may be a better method than using SendKeys.
Are you recalculating just one cell?

BSB