Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
concatenating in excel
Name: bjim217 Date: October 31, 2006 at 17:20:42 Pacific OS: xp CPU/Ram: p4 2GB Product: dell
Comment:
Can someone help me with my problem of concatenating values in various cells in excel BUT I want to maintain the fonts used - I think I need a macro to do this as excel applies a single format to the final cell
basically I need to take one cell in 14pt courier new, and concatenate with another in bold, italic 14pt courier??? The added complication is that the cells to concatenate are results of a LEFT() command with the formatting (bold etc) applied to the cell afterwards.
I am rather stuck, short of concatenating and going throug the cells by hand to change the desired letters!!!
Summary: As it is a csv file, it is only plain text and will loose any formatting you do on it when you close it (as you have already figured out.) If you only use it in excel, save it as an excel sheet rathe...
Summary: Try these two lines: Rows("1:1").Copy Windows("Book2").Range("A1").PasteSpecial Paste:=xlValues, Transpose:=True The operation to convert between horizontal and vertical is "Transpose:=True" If you do...
Summary: I'm building a test matrix in Excel and for some reason the macro that I am writing is having a problem reading the cells in the range that I pass to the functions. The test matrix is a workbook compr...
How to automate app;icati...
