Thread: Choosing offset on condition found in combobox change colour of cell??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_816_] Simon Lloyd[_816_] is offline
external usenet poster
  
Posts: 1
Default Choosing offset on condition found in combobox change colour of cell??

This post is on from a previous post
http://www.excelforum.com/showthread.php?t=557701, i have tried various
combinations after the Case element but i cannot seem to select or use
"r" and if i dont the code below stops at the With Sheets(wks.Name).

Any ideas?

Regards
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=557873

Reply With QuoteReply With Quote