Thread: Case Select
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NoodNutt NoodNutt is offline
external usenet poster
 
Posts: 221
Default Case Select

Thx again Bob.

Just a couple of follow up questions if I may.

1. the date format in your response, is it

(yyyy,mm,dd) or (yyyy,dd,mm)

2. with the 'Do Something

What would be the best way to move the focus from the Target.Value Cell, to
the Cell at the immediate right.

By that I mean, if the Target. Value Cell = G5, then I need the response in
H5 to = "SEP".

Regards
Mark.