Hi Bernd,

Thanks for your help.
I figured out the source of my confusion.
See my answer to TOms email

Thanks
Suzanne

"Bernd" wrote:

Hello,

I cannot repeat this:
Option Explicit
Sub test()
Dim theStartingCell As Range
Set theStartingCell = Range("A5")
Debug.Print "starting " & theStartingCell.Address
theStartingCell.Interior.Color = vbRed
Debug.Print "starting " & theStartingCell.Address
End Sub

Do you have any event routines enabled?

Regards,
Bernd