Append text in bold cells

[ajaykgarg]

Hi

I want to find all bold cells in column M and append a semicolon ( ; ) at end of such cells.
I have written the following sub for that.
While this does what I want, is this the most efficient way, or is there a better way?
(I am assuming that I have to do it only for rows 3-9)

tia
Ajay

Please Login or Register  to view this content.

[docMed]

Seems pretty efficient to me - Whenever you have to use the find/search feature of excel you're going to get a bit of slowdown.

The only other way to really test it would be to write a do/loop until that checks if the value of the cell contains bolded characters. It's probably easier just to stick with what you have and it wouldn't be much quicker, if any bit at all.

[MaczaQ]

Try this code for change all cells in column M which have font.bold style

Please Login or Register  to view this content.

Best Regards
MaczaQ

[snb]

@maczaq

Please Login or Register  to view this content.

[MaczaQ]

@maczaq

Please Login or Register  to view this content.

As always Thank you snb for showing me better way...

Best Regards

[ajaykgarg]

Thanks, snb and others. This does what I wanted with fewer lines of code.

[ajaykgarg]

snb,

I think

Please Login or Register  to view this content.

doesn't work with 2010.
How can I customize this for 2010?

Also, where can I find a list of changes in 2010?

Thanks
Ajay

[Mordred]

according to your profile, you use Excel 2007 and it works on it without error (unless there are no values in columns(13) then it will fail. I don't see why it wouldn't work on 2010 but I am going to test it when I get home tonight.

[ajaykgarg]

Modred, did you get a chance to test it on 2010?

[Mordred]

Sorry for not responding but yes and it worked without error for me.