putinclipboard

Hi All, I was using the below macro to copy a cell location so I could go elsewhere in the workbook an paste it. It worked fine until I updated to Excel 2016. Now when I paste, it pastes 2 question mark boxes (Char(63)). Any ideas? Thanks! Sub CopyLoc() On Error Resume Next Dim...

Hi, I previously used the following macro to copy a cell address to the clipboard, and subsequently paste elsewhere: 'Public Sub CopySelectionAddressToClipboard() Dim rngT As Range Dim strAddress As String Dim dobClip As DataObject If Application.Selection.count = 0 Then Exit Sub...

Hi, My first post! Hopefully all inline with Forum rules ... :) I'm a relatively experienced Excel / VBA user, but I've come across an interesting problem. I develop/own a large set of workbooks that contain code, and recently users have been complaining that Excel has been hanging, with no...