Copy only bold face cells?

tleonardo1 · Apr 2nd, 2002, 03:07 PM

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.

Tom Schreiner · Apr 2nd, 2002, 04:28 PM

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

Jack in the UK · Apr 2nd, 2002, 06:40 PM

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 · Apr 3rd, 2002, 02:02 PM

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

Apr 2nd, 2002, 06:40 PM	#3
Jack in the UK Join Date: Feb 2002 Posts: 3,063	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.. __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 03:07 PM	#1
tleonardo1 Join Date: Apr 2002 Posts: 48	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.

Apr 2nd, 2002, 04:28 PM	#2
Tom Schreiner Join Date: Mar 2002 Posts: 6,677	Hi I could be wrong, but I can't think of anyway to do this without VBA macros??? Tom

Apr 3rd, 2002, 02:02 PM	#4
tleonardo1 Join Date: Apr 2002 Posts: 48	Ok...can someone give me the right command to use in VB?