View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 172
Default Matching Value placed in next column

I am still to work out an effective solution to this:
I have a list of dates in a (mmmm yy) format in Sheet1 Range(B17:B28)
At the end of a macro in another sheet I want to place Now() in a
(mmmm yy) format in the Cell NEXT to the MATCHING Value in Column C.

I have yet to workout how to MATCH the values so the MATCHING mmmm yy
is placed NEXT to the mmmm yy in Column B.

I need to code this as say:

If Now() = Sheet1.Range(B17:B28).Cells.Value then
Sheet1.Range(B17:B28).Cells.Activate
ActiveCell.Offset(0,1).value = Now()

end sub



How can I code this logically to actually work?

Corey....