Copy Paste Special

[sj1601]

Hi All,

Is there keyboard shortcut for pasting values? I have to repeatedly perform this task and would save me a lot of time if I simply did ctrl+c and then the keyboard s/cut for paste value.

Thanks.

sj1601

 

[tvkrys]

firefytr -

...I highly disagree about SendKeys though. They are very unstable IMHO, I stay waaay clear of them.

Excuse my ignorance, but what does "IMHO" mean?

I imagine if you had a SendKeys with lots of steps to it there might be problems - especially if you don't untilize waits as needed. But, my "PS-Formula" doesn't require any delays and it's been in use for several months now with no problems what so ever.

K-

 

[Zack Barresse]

Sorry, IMHO = In My Humble Opinion.

SendKeys can be a good method, sure, and it comes through in a pinch. But debugging and troubleshooting a routine laden with SendKeys methods is a PITA (Pain In The A**). Plus it can be a resource hog and, if the user(s) have a slow computer or has the focus on something other than the intended object(s), then the code has more tendency to fail on you.