| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Obtaining a certain date from columns
Goddag, how do I make a macro that can get the latest date in a column.
Like I have many dates in that column and I want to get the newest date. Thank in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Obtaining a certain date from columns
The latest data would be the Max value in the column. If you were using a formula it would be =max(A:A) The equivalent VBA code would be Dim MaxDate As Date MaxDate = WorksheetFunction.Max(Columns("A")) -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=152305 Microsoft Office Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Obtaining just the Year out of the date | Excel Discussion (Misc queries) | |||
| generate report from date and obtaining all data in row | Excel Discussion (Misc queries) | |||
| Obtaining min and max | Excel Programming | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Hybrid Mode
