Copying Table information out of a Macro

[healynviii]

Hi,



I've been running a Macro that highlights certain cells with a colour to enable better search results, However when i try to copy this information and paste it into another Excel document it does not take the colour highlight with it, even on a paste special?!?

Is their a way of doing this??

Kind Regards

Neil

 

[Andrew Poulsom]

Is the other Excel document in the same instance of Excel?

 

[healynviii]

No, its a brand new file.

 

[Andrew Poulsom]

Sorry, I don't understand. For Copy/Paste between workbooks to work correctly both workbooks must be in the same instance of Excel. Otherwise it's like Copy/Paste between different applications.

 

[healynviii]

oh i see apologises, yes they are both in the same instance.

 

[Andrew Poulsom]

Then Copy/Paste will include formats. How are the cells formatted?

 

[healynviii]

as i see them just a simple conditional format, but its deroved from the macro running it and i didn't create the macro. can you upload documents on here for checking?

 

[Andrew Poulsom]

Can you post the macro?