Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matching down a column | Excel Worksheet Functions | |||
column matching | Excel Discussion (Misc queries) | |||
matching from one column to another | Excel Discussion (Misc queries) | |||
matching from one column to another | Excel Discussion (Misc queries) | |||
Matching cell in one column to value in another | Excel Programming |