Hello,
Here is the solution
*Assumptions*
*First row is column heading*
*and second row date value is correct*
Sub BhavaniMacro()
'Written by Jayaraj.metta@ gmaill.com
Dim iDate As Date
Dim Lastrow As Long
Dim iRow As Long
Dim ImputeDates As String
Lastrow = ThisWorkbook.Act
Hi
I have date column in first column
9/27/2011
9/28/2011
9/29/2011
9/30/2011
10/1/2011
10/3/2011
10/4/2011
10/8/2011
But some Dates are missing intermittently and I want to impute missing
dates.
I am looking for a VBA macro to do this task.
I appreciate you help in this regard
Regards