View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernd Bernd is offline
external usenet poster
 
Posts: 92
Default Three lines of code that I can't understand

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