View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Keith Wilby Keith Wilby is offline
external usenet poster
 
Posts: 40
Default Conditional Formatting Strangeness

"Peter T" <peter_t@discussions wrote in message
...
With your relative addressing everything is relative to the active cell,
try
changing -
).Address(False, False)
to
).Address


Hi Peter, I spoke too soon as all of the cells in the range now reference
row 2.