Merging Cells

[roasty_1]

Hi

I have a column with data, the cells go data, blank cell, data, blank cell, data etc.

The row count will vary.

What I need to do is go through the non blank cells in the column and merge the them with the blank cells beneth them.

ie A2 = Apple
A3 = blank
A4 = Pear
A5 = blank

run the code to get

A2 and A3 = Apple
A4 and A5 = Pear

Thanks

[VBA Noob]

Link should help to fill the blanks

http://www.contextures.com/xlDataEntry02.html

VBA Noob

[royUK]

Don't merge cells, you will experience problems eventually

[VBA Noob]

Don't merge cells, you will experience problems eventually

Roy,

I read it as the OP needs to fill blanks

VBA Noo

[royUK]

I thought the OP wanted to merge the cells to one

[roasty_1]

Thanks for the answers

Merging the cells are ok for this excerise, so I will stick with them

Excel file attached to show what I mean.

The list could change length so I would need to add a piece of DO LOOP code

[VBA Noob]

As Roy suggests you should avoid merge cells.

If you must then try

Please Login or Register  to view this content.

VBA Noob

[shg]

Just to add my voice to Roy's, merging cells is a uniformly bad idea if there is any downstream dependency - formulas, VBA, anything.

[roasty_1]

thanks, I will give this a go

the cells that are to be merged are static data, just headings.

Cheers all

[roasty_1]

VBA Noob

sorted

thanks