Excel - Adding a border on every 5th row

Scripting Forums AppleScript | Mac OS X
,
#1

I’m new to Apple and trying to learn Applescript. I just want to know how to add a bottom border to a row that includes 8 columns “A8:L8” and have it repeated every 5 rows up to the amount of data in the worksheet. Any help?

#2

I think this will do what you want.

tell application "Microsoft Excel"
	set myRange to range "A8:L8" of active sheet
	repeat until value of cell 1 of myRange = ""
		set weight of (get border of myRange which border edge bottom) to border weight thin
		set myRange to get offset myRange row offset 5
	end repeat
end tell

http://www.microsoft.com/mac/developers/default.mspx?CTT=PageView&clr=99-21-0&target=4acff5ca-5863-4bb6-9a3b-09d2bc0d1dc71033&srcid=e1dbbe49-e45b-4606-bc00-dc5d3bd2d4601033&ep=7
is a good resource for Excel AppleScript.