Help with code

I need to highlight a range of cells and I was wondering if I could use this code.
body = (sheets("sheet1").cells(range of cells))
I know I can select one cell with that code but is there a way to select a range of cells
Thanks

Know someone that owns a child care business. Go to www.kidkeeper.net. It will help them greatly

You need to use a range object like
Sheets("Sheet1").Range("A1:D4")

I think therefore I am... sometimes right. images/icons/wink.gif

To select non-contiguous ranges, use a <font color=blue>,</font color=blue> like this:

Sheets(1).Range("A1:A2,C3:D4").Select


"Recently reported by the Assoc. of Incomplete Research, 7 out of 10 people." -- K. Nealon, SNL