koden Posted October 23, 2022 Report Share Posted October 23, 2022 Hi I have a excell sheet with a lot of cells with numbers. My macro copy a number and uses the number on a website. it goes back to excell and copy next number. How do I in the excell sheet mark the just copied number ex. BOLD, so that this number is bold in excell (I can then see that this number has been "used")? I thought it was a text command, but did not find any command matching. Quote Link to comment Share on other sites More sharing options...
rberq Posted October 23, 2022 Report Share Posted October 23, 2022 You can bold the selected cell in Excel by typing Ctrl-b. In a macro, the command would be Text Type (Simulate Keystrokes): <CTRLD>b<CTRLU> However, in my version of Excel, bolding a cell clears the value in the clipboard. So bold it BEFORE you copy it to the clipboard, not after. Quote Link to comment Share on other sites More sharing options...
koden Posted October 23, 2022 Author Report Share Posted October 23, 2022 yes off course... I must have been tired 🙂 Thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.