Is it possible to have excel format a range if it has been copied to clipboard?
I have a page with several ranges that I would like to copy from excel to other software. As there may be several ranges (14 rows each seperated by a blank row) to copy, it may become difficult to keep track of the data I have copied. I would like to be able to apply formatting, (change cell colour) once a range has been copied to keep track of where I am upto.
I have been able to use the BEFORE RIGHT CLICK code in VB to cover te right click copy method but is there a better way that will also cover the EDIT>COPY and CTRL+C copy methods?