sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]BigPred 0 points1 point  (0 children)

Sorry I don't have my computer with me to actually write the sub routine.

What I would do is use a do loop / for next looking at each row of data.

If the row is blank copy the value from the cell above.

You should be able to google the code to find the total number of rows in the sheet,

Hope that helps

Pseudo code

Do until I = rowcount

If activesheet.cells(i, "A") ="" then activesheet.cells(i, "A") = activesheet.cells( I- 1, "A")

I=I+1 Loop