Jump to content
Macro Express Forums

Paste Option in Excel


george_b
 Share

Recommended Posts

Hi,

 

 

I'm doing a script which copies data from a form and paste it into an Excel sheet. Because it uses a different format than Excel, I must use the Paste Options button in the right corner of the paste region. Is there a hotkey or any other way to access this button?

 

 

Regards,

George

Link to comment
Share on other sites

I must use the Paste Options button in the right corner of the paste region.

 

I'm not quit sure what you mean. Is it paste in Excel? If it is, you can do this (I heavn't an english version of Excel so i can't guide you directly). Do a Text Type: <Alt> and then navigate tru the underlined letters, in my case it would be like this: Text Type <Alt>Rc<Enter>.

 

Hope this help you.

Link to comment
Share on other sites

Hi again,

 

 

Thanks for the quick feedback. I found what I was looking for on Google. Actualy "the Paste Options button" is a smart tag and the hotkey for accesing smart tags is ALT+SHIFT+F10 after you paste into Excel and then use the arrows.

Hopefully next time I'll google it first and ask later.

 

 

Regards,

George

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...