Re: $$Excel-Macros$$ Imputing date

2015-12-20 Thread jayaraj metta
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

$$Excel-Macros$$ Imputing date

2015-12-20 Thread Bhavani
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