Hi,
I have the following problem:
In a workbook, I have text cells which are a result of concatenating the text in two different columns. In the sample workbook, these are cells D3:D6.
In the adjacent column, I have text cells which are the exact same text, but directly input by typing in each cell. In the sample workbook, these are cells E3:E6.
Column F contains a check to verify that the content of both columns is the same for each row.
Now my problem. I want to change the font of the text but only for the first three characters (the numbers). To this end, I have employed the following VBA code:
When the code is applied to the concatenated cells (column D) it changes the WHOLE cell to bold.Please Login or Register to view this content.
When the code is applied to the directly typed-in cells (column E) it changes the correct characters (just the first three).
Obviously, my problem is that I need to perform this action on a large number of cells and therefore need to use VBA code, and the cells are all results of CONCATENATE functions.
In enclose the workbook for clarity.
I think the selection of characters bit and changing the format is OK (I did Debug.Prints and they look fine). It might have something to do with the way VBA interprets text from CONCATENATE function (as different to directly typed in text).
Any thoughts will be greatly appreciated. THANKS IN ADVANCE.
Bookmarks