Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching date
Can someone show me how I would write code to search a worksheet for specific date and then paste my selection to the cell next to it Thanks. -Jerem ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
searching date
Dim dDate as Date
Dim rng as Range Dim res as Variant dDate = DateValue("12/21/2002") set rng = Range("C1:C200") res = Application.Match(clng(dDate),rng,0) if not iserror(res) then rng(res).Value = activecell.value End if -- Regards, Tom Ogilvy "Irunalotta" wrote in message ... Can someone show me how I would write code to search a worksheet for a specific date and then paste my selection to the cell next to it. Thanks. -Jeremy ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
functions searching by date | Excel Discussion (Misc queries) | |||
Searching a date range to output values according to a constant. | Excel Discussion (Misc queries) | |||
Searching a date range to output values according to a constant. | Excel Discussion (Misc queries) | |||
Searching a date | Excel Discussion (Misc queries) | |||
userform with date searching in worksheet | Excel Programming |