help with code that fills in blanks

[ammartino44]

Hello. Can someone explain this code? It's for filling in labels where there are blanks, so A1= Jim A2:10=Jim A11=Bob A12:A20= Bob etc. How does the second line do this? It seems like it's just copying everything from A1. And the first line is saying copy cell before but how does it know to start from the top?

Please Login or Register  to view this content.

[berlan]

Hi,

if there are no blank cells within the currentregion, using specialcells will return an error, which is why the line

Please Login or Register  to view this content.

is used.

The formula "=R[-1]C", which is applied on the blank cells, will give you a reference to the next cell (one row up). If row 1 withing the currentregion is blank, consider changing changing the code for defining the range area -- you may also want to limit this to specific columns?

another alternative that does the same,

Please Login or Register  to view this content.

hope it helps -- on vacation so maybe not the most detailed post..

cheers, berlan