Hi I am trying to fill empty cells with the content above the empty cell.
For example A1 = rrrr A2-A5 is blank and A6 = ffff A7-A9 is Blank.
I wrote this function to do what i want. how ever it only does it once. I want to loop it. I have entered End at the end of the data so I want to keep calling the funtion until i reach End and then ext sub. and move on.
Any help is appriciatedPlease Login or Register to view this content.
Bookmarks