Problem with ""

[jp16]

Hi, anyone know how to sort data and excel will treat "" as blank? Coz i have a list of data, which include some empty row (which is ""). I try to sort, however, the "" will all be on top. How do i solve this?

And aso, anyone know how to delete row which is blank ("") using VBA?

[tom1977]

Answering second question You can use

if isempty(Your variable) then
Your variable.delete

If you want delete and move cells up start loop from the bottom of range to up

[jp16]

Answering second question You can use

if isempty(Your variable) then
Your variable.delete

If you want delete and move cells up start loop from the bottom of range to up

huh? u mean type =isempty? Its a formula or a vba command? Never heard before isempty. I not that good at excel.

[tom1977]

send a sample and I will send you back code
isempty is VBA command

[Marcol]

Try this ...
1/. Filter your data for blanks in the column you need to evaluate.
2/. Select, and then delete the resulting rows
3/. Sort the data as you require.

No VBa or formulae required.

[jp16]

send a sample and I will send you back code
isempty is VBA command

How to send a sample? Whats your email?

[tom1977]

jp16 upload sample here on forum (please read the rules and You will know how to do it)