Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Update
How can i have a macro find a date at the end of a column and then update it to the next cell, in visual basic code
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Update
Tim,
cLastRow = Cells(Rows.Count,"A").End(xlUp).Row gets the last cell in column A. By update next, do you mean add 1 day to the date? If so, then Cells(cLastRow+1,"A").Value = Cells(cLastRow,"A").Value + 1 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Tim" wrote in message ... How can i have a macro find a date at the end of a column and then update it to the next cell, in visual basic code |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clarification - how to automatically update cells with a date and date range | Excel Discussion (Misc queries) | |||
Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
input a date or update it based on date in another cell | New Users to Excel | |||
How to update a cell if a specific date is included in a date rang | Setting up and Configuration of Excel | |||
Date update on data update | Excel Programming |