PDA

View Full Version : Active Cell = Bolding



IcePirate
01-06-2009, 11:58 AM
Hello,

(I have attached an example)
I have a script that will create a word document based on information that has been inputted into the cells on this excel sheet. (To create the document look at cells X, Y)

What I want to do is bold certain content that comes from the excel sheet and is displayed on the word document.
For example, the date which is in column 1...I tried addign
ActiveCell.Font
.Bold = True
Into my code, but when I try and run the script it just creates a word document that says, 'False'


Does anyone know why thats happening, or could anyone provide some advice on bolding certain text in the word document.

Simon Lloyd
01-06-2009, 12:19 PM
I haven't looked at your example but the code to bold the activecell's font isWith Selection.Font
.FontStyle = "Bold"
End With

lucas
01-06-2009, 12:55 PM
Whew, that's going to be a maintenance nightmare......screams for a template solution.