Re: Trouble including paste special in macro
Quote from Grimes0332;768820
You need to explain. The additional code you posted uses ADO to get records using CopyFromRecordSet. There are no 'formats' to paste.
Thanks for the comment, as you can probably tell I really don't know much about vba (just learning some stuff).
In my original dataset it has borders around the data and some of the cells has red text. I was just trying to find a way that when it copies the data to paste it with the original cell formatting. Thanks