Hi,
In the attached excel file, First cell will have text "A" and then few cells will be blank in that column then text "B" will come. now I need a VBA Coding which will copy the A to all the blank cells in that column till it reaches B, and likewise it should copy the same data to all cells in that column till it get a break like this.
Pls help me in providing the VBA script.
Last edited by BALA1983; 11-12-2015 at 03:12 AM.
Where does the last row end?
Sub fillme() With ActiveSheet.Range("B1:B" & Range("B" & Rows.Count).End(xlUp).Row) .SpecialCells(4).FormulaR1C1 = "=R[-1]C" .Value = .Value End With End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
BALA1983 
Register To Reply
Bookmarks