Refering code to work on just one column

[kjshep]

This code grabs the blank cells and pastes whatever above into it. Im needing it to do this just in column A.

Please Login or Register  to view this content.

This link shows what im trying to do!

http://www.extendoffice.com/document...lue-above.html

Thanks

[jeffreybrown]

Try

Please Login or Register  to view this content.

but if you want to be left with only the values

Please Login or Register  to view this content.

[AB33]

As you are selecting the range, you only need to select columns(1) if you just want column A only

[HaHoBe]

Hi, kjshep,

limiting it to the range or entries in Column B:

Please Login or Register  to view this content.

Ciao,
Holger