Doing copy/paste operations in VBA without using the 'real' windows clipboard?

[relaxok]

Hi all -

I run VBA macros all the time that take 20-30 minutes in some cases - I generally run them on a secondary machine, not my primary machine. However one issue I've had is that since newer 'remote' solutions like the windows 10 version of Remote Desktop and VMWare Horizon/Blast share the clipboard (very useful in many cases) of the target OS, it has side effects. Any VBA running on my secondary machine, if I have the Remote Desktop client or VMWare client open, even if it's minimized, when the VBA does a 'copy' clipboard command, I find myself pasting gibberish on the main machine, not realizing a scheduled VBA task ran on the other machine. Or even when you ignore the 'other machine' clipboard issue, it means I can't really run VBA that uses the clipboard on the main machine itself without possibly messing up my copy/paste operations I'm doing elsewhere.

So I guess my question is, is there a way to use the functionality of Cut/Copy/Paste in VBA but using an 'internal' clipboard that doesn't affect other applications or the OS?

Thanks!

 

[Legacy 143009]

Set your cell values without copying?

Range("B1").Value = Range("A1").Value

 

[relaxok]

Set your cell values without copying?

Range("B1").Value = Range("A1").Value

I'm not sure I can convert all this complex stuff like selecting ranges of rows to .Cut and then .Insert-ing them elsewhere, etc.

 

[MARK858]

I'm not sure I can convert all this complex stuff like selecting ranges of rows to .Cut and then .Insert-ing them elsewhere,

For a range...

Sub ResizeValues()
With Range("A1:B10")
  Range("Z1").Resize(.Rows.Count, .Columns.Count).Value = .Value
End With
End Sub