Functions, select or paste from ClipBoard

S

Steve Elster

Hello,
With Excel 2000, in a Function, can
1. Ask a function to select a range, or insert a value into a range?
2. Or can I ask a function to call a sub routine that does this?

3. Or, is there a way to programmatically paste something from the
ClipBoard, using VB in excel?

I can't seem to find a ClipBoard function or command in Excell 2000,
in VB or in the help. I have tried to get around this by selecting a
range like

Range("a20").select '' then pasting something in
ActiveSheet.Paste

The problem is that the Range("a20").select does not seem to select
anything -- can't see it do anything in the spreasheet -- executed in
a function ??? ??

Thanks
Steve
 
S

swatsp0p

you are missing the "copy" step. this will put the data on the clipboard.
then you can paste. looks like this:
Range("H4").Select
Selection.Copy
Range(nTheRange).Select
ActiveSheet.Paste

HTH

swatsp0p
 
Top