Excel 08: Bold a row, freeze panes, sort range?

Scripting Forums AppleScript | Mac OS X
#1

Heya! I’m doing a bit of Applescripting in Excel 2008, and am a little bit stuck on a few things.

First thing I need to do is bold specific rows where the value in the column M is “1.”

Next, freeze panes, just the top after the 3rd row.

Any recommendations, either how to do this or on resources? The Excel 04 scripting reference guide is, well, a little bit obscure… :wink:

Thanks!

[Edit: Figured out a sorting issue…)

#2

Sweet. :smiley: Sorry for a delayed reply.

Dare I ask how you learn to do this kind of scripting? Is there a reference that I’m missing?

Thanks!
S

#3

OK 50% sweet. :wink:

Freeze panes works perfectly, the bolding script does nothing. (I can deal, but automation would rock.) Any recommendations?