how do i select two individual cells using the cells propertly to format in
the same way.
ie Range (Cells(5, 4) and
Range(Cells(5, 5)

so that i get a border line around each one

--
with kind regards

Spike


"Spike" wrote:

I will be very grateful for the code to select two ranges at the same time.
I am formatting these ranges with borders etc and rather than do each one in
turn would like to do them at the same time. The two ranges are as below.

Range(Cells(5, 4), Cells(intRows, 5))

Range(Cells(5, 6), Cells(intRows, 7))

Everything I have tried selects the whole area and not separately, using D5
etc is simple but as this is dynamic I need to use the Cells property

many thanks
--
with kind regards

Spike