Copy only bold face cells?

[tleonardo1]

Is there anyway to copy only those cells that are boldfaced in column C to column A? preferably a formula in a cell vs a Macro? The reason is I want to copy all italic ones to column B but Ineed them to stay in the same row they are in column C.

 

[Legacy 98055]

Hi
I could be wrong, but I can't think of anyway to do this without VBA macros???
Tom

 

[Jack in the UK]

Hi

This will only be done with VBA as you are asking for an action to take place.. Formula return answers only.. Macro can do both...

Does this help..

 

[tleonardo1]

Ok...can someone give me the right command to use in VB?