Excel formatting from VB (almost there!)

[Tommyhat]

I'm trying to add a back colour if the user has set collumn heads on in a flexgrid.

so i had this code from what ive gathered from looking up old posts:

If mnuHeadOn.Checked = True Then
ws.Range("A1:A5").Select
ws.Selection...
End If

but it complains my worksheet (ws) doesnt support .selection

first, what do i use to refer to the cells i selected with .select
second, what's the syntax to change back colour?

Thanks a bunch!

 

[Tommyhat]

I figured it out myself.

ws.Cells(j, m).interior.colorindex = 15