VBA Macro to eliminate cells with a blank value

**paulxl** · 01-24-2012, 04:03 PM

I'm looking at Chip Pearson's VBA code to eliminate blank cells (copied below) and realise that this will not work with cells that have a " " value. Is there any way to modify this so that it will return values from a list containing those " " values?

Please Login or Register  to view this content.

**jaslake** · 01-24-2012, 05:02 PM

Hi paulxl
Welcome to the Forum.
Please wrap your code in Code Tags as per Forum Requirements.

**mrice** · 01-25-2012, 09:52 AM

Try replacing..

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

**paulxl** · 01-26-2012, 09:14 AM

Martin

This will pick up the first non " " value in the range but then repeats that value instead of ignoring the next range of " " values and picking up the rest of the real values.

eg. If my data range comprises " ", " ", 34h, " ", " ", " ", 72h, " ", 104h...... I just get a " " in the first cell which I can live with then 34h in every cell thereafter when I need to return 34h, 72h,104h........

Paul

**paulxl** · 01-26-2012, 09:15 AM

Martin

This will pick up the first non " " value in the range but then repeats that value instead of ignoring the next range of " " values and picking up the rest of the real values.

eg. If my data range comprises " ", " ", 34h, " ", " ", " ", 72h, " ", 104h...... I just get a " " in the first cell which I can live with then 34h in every cell thereafter when I need to return 34h, 72h,104h........

Paul