| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to scan range
My range, C2:AA2 contains weekday dates for any given month.
I want code that will look through that range and find the last Friday. eg. lastFri = ActiveSheet.Range("C2:AA2").Find(<the last Friday) For my needs, this must be a VBA solution. Any help? -- David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i fax a scan | Excel Discussion (Misc queries) | |||
| Virus scan | Setting up and Configuration of Excel | |||
| how do i scan documents | Setting up and Configuration of Excel | |||
| Scan Forms | Excel Discussion (Misc queries) | |||
| Scan range of rows and export to 2nd worksheet | Excel Programming | |||
Threaded Mode
