Thread: If X and Y then Replace Y
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excel-ant excel-ant is offline
external usenet poster
  
Posts: 26
Default If X and Y then Replace Y
You may need to add the following line at the start

Dim c as range.

since c.Offset means nothing if c is not a range/cell.

http://www.excel-ant.co.uk

Reply With QuoteReply With Quote