Hello Everyone!
Kindly refer to http://www.excelforum.com/excel-prog...r-methods.html
When i run following code on the worksheet i attached, it produces correct results, i.e. replacing the whole dates with only "Day" for whole column untill lastrow.
But, it reduces the "Day" by 1 in "Posting Date" column each time when i run the code again.
For example after running the code for first time if the value was "1", running it for 2nd time produces 31, running it again would bring 30, and so on.
Why is it reducing the value by 1 each time?
I am also attaching the sheet.![]()
Please Login or Register to view this content.
Thanking in advance
Bookmarks