VB in MS Excel

[sweep123]

I need to change the name of an item in a Excel cell and then change its colour - repeatly.

But dont know how any items are in the Worksheet.

i.e. its peoples initials; want to just add initials then have VB globally replace the initials to full name and have males in Blue and females in Red.

I can do a global replace, but need to change the font as I process each one, could do a For Loop but how do you know how many there is?? The initials can appear many timese.g. JF 6 times, RS 3 times.

 

[MakeItSo]

Hi sweep123,

a) your question relates to VBA, not VB. -->forum707
b) "...it's peoples initials; want to just add initials then have VB globally replace the initials to full name..."
So you only have initials in your sheet? How can you identify the name then? I assume you have other identifying cells.
In this case you might go best with a Lookup table instead of code.

Do a keyword search in above mentioned forum, or in
MSOffice forum:forum68 in order to get what you need.

Hope this helps,
Andy

[blue]The last voice we will hear before the world explodes will be that of an expert saying:
"This is technically impossible!" - Sir Peter Ustinov[/blue]
andreas.galambos@bowneglobal.de
HP:

http://andygalambos.de