Gord - Thanks for responding.. and I agree
With you ..

"It worked! Thank you :) "

Whatever floats your boat, ehh..



"Gord Dibben" <gorddibbATshawDOTca wrote in message
:

I guess OP would be the one to answer that.

Aline's response was "It worked! Thank you :) "


Gord

On Thu, 18 Jan 2007 13:38:23 +0000, "JMay" wrote:

Gord,

It's just that the OP's dataset looks exactly like a table, say

FName LName City
Jim May
Bill Atlanta
Gord Didden New York

OP said:
I have
sporadic blank cells throughout the dataset and want to delete them

So how is the above dataset going to LOOK after
The Blanks are deleted? <<that's my Q

Thanks,



"Gord Dibben" <gorddibbATshawDOTca wrote in message
:

They are not "nulls".

They are the "" results of formulas that returned no data so she wants them
shifted up for alignment purposes.


Gord

On Thu, 18 Jan 2007 00:49:41 +0000, "JMay" wrote:

This whole thread "blows-my-mind" the fact that
Alina wants to DELETE the blank cells which are
Nulls as far as I see it.

What am I missing here?



"Gord Dibben" <gorddibbATshawDOTca wrote in message
:

Should read "not" part of the code.

Gord

On Wed, 17 Jan 2007 16:19:16 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

The ' lets Excel know it is part of the code.