After all the explanations you have, maybe it's time to experiment.

Create a new worksheet (and make sure it's active).

Then run this macro:

Option Explicit
Sub testme()
Dim myRng As Range
With ActiveSheet
.Cells.Interior.ColorIndex = xlNone
Set myRng = .Range("a1:c1,f9,h12")
myRng.Interior.ColorIndex = 5
myRng.Offset(1, 3).Interior.ColorIndex = 3
End With
End Sub

Change myRng to any range you want, then look at the colors on that sheet.

Then experiment with the .offset() numbers.

And when you're done, take a look at the .resize() property, too!

donna wrote:

can anybody explain offset propety to me please?

Many thanks

--

Dave Peterson