Excel Cell Style Formatting

Scripting Forums AppleScript | Mac OS X
,
#1

hello all,

Using excel 2004 how would you go and change the style format of a cell to bold? and/or other variations? Would anyone have an code that I can look at to accomplish this?

thanks

#2

You can do this within an Excel tell block:

– first set your cell range. Suppose you are working on sheet 2 and want to target cell B9. So:

set myRange to range “B9” of sheet 2 of active workbook

– now set your formatting:

set bold of font object of targetRange to true

#3

thanks

here’s the code


tell application "Microsoft Excel"
	
	set myRange to range "B1" of sheet 1 of active workbook
	
	-- now set your formatting:
	
	set bold of font object of myRange to true
	
end tell