Oct 31 2022 08:55 AM
I've just discovered that a VBA program I wrote years ago has stopped working when copying and pasting a range of cells, with only the values being copied, the cell fill and font colors no longer being copied. Here is the line of code I've successfully used for years that's stopped working.
'Copy Columns I-J
wboWBO.Sheets("SheetName").Range("I6:J29").Copy .Range("I6:J29")
Previous to last week, this worked without fail, now only copies values, not formatting. Please advise ASAP and fix.
Steve
Oct 31 2022 12:21 PM
Seems like it could be an issue with the Office clipboard not fully gathering the values. The clipboard can glitch like this every so often. My go-to is to open the clipboard and test copying ranges manually to see how the clipboard takes it in:
The green icon is a good sign. When the clipboard gives you the blank white sheet of paper then it's only gathering in values with no formatting. Clear the clipboard and keep pressing copy until it begins working again. It's one of those things that comes and goes.
Oct 31 2022 12:28 PM