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.
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:
Application.SendKeys "{ENTER}"
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.
What is it you're actually trying to do? There may be a better method than using SendKeys.![]()
Sheets("Sheet1").Range("C1").Select Application.SendKeys "{F2}" Application.SendKeys "{ENTER}"
Are you recalculating just one cell?
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks