For Loop not completing

Hi All,

I am relatively new to macro and I was trying to use For loop in my code. It appears the loop is not running till end. My excel has some date columns but there are few columns where there is a gap in date between two consecutive columns. So what I was trying to do is to insert a column whereever there is a gap. and fill out the column header with the appropiate coulmn value. Below is the code that I wrote:

Please Login or Register  to view this content.

on executing the code the value that I am getting for i is 40 and of last col as 52 (lastcol is the last column of the datarange).

Will deeply apreciate if anyone can guide me on the mistake that I am making.

Thanks
-Som

Hi somnath.deb

When adding/deleting columns or rows iterate through them backward (rows from the bottom up, columns from right to left).

Please Login or Register  to view this content.