Sort A to Z Ignore blanks

[hajiali]

this code below will Sort the Columns However, It puts the blank cells on top

Sub SortRampLog()    ActiveWorkbook.Worksheets("RAMP LOG (2)").AutoFilter.Sort.SortFields.Clear
    ActiveWorkbook.Worksheets("RAMP LOG (2)").AutoFilter.Sort.SortFields.Add Key:= _
        Range("A2:A1000"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption _
        :=xlSortNormal
    With ActiveWorkbook.Worksheets("RAMP LOG (2)").AutoFilter.Sort
        .Header = xlYes
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
End Sub

In row A2:a1000 I have the following code

=IFERROR(CONCATENATE(INDEX('EMPLOYEE LIST'!$D$2:$D$1000,MATCH(B3,'EMPLOYEE LIST'!$B$2:$B$1000,0)),", ",INDEX('EMPLOYEE LIST'!$C$2:$C$1000,MATCH(B3,'EMPLOYEE LIST'!$B$2:$B$1000,0)))," ")

I have tried Putting "0" and "-" if error happens
any suggestions is very appreciative

 

[JoeMo]

In the event of an error, your IFERROR formula is returning a space (" "). Try changing that to a zero-length string ("").

 

[hajiali]

Tried "" and still same results when i Sort A to Z Blanks at the top.

 

[hajiali]

I got it figured out. for anyone that would like to know just Remove the Iferror

[COLOR=#333333]CONCATENATE(INDEX('EMPLOYEE LIST'!$D$2:$D$1000,MATCH(B3,'EMPLOYEE LIST'!$B$2:$B$1000,0)),", ",INDEX('EMPLOYEE LIST'!$C$2:$C$1000,MATCH(B3,'EMPLOYEE LIST'!$B$2:$B$1000,0)))[/COLOR]

The cells will have "#N/A" but will not sort those cells with "N/A"