Hello,
I am trying to sort a range which contains number by having the blanks sorted out first. Is there a formula or vba solution to achieve this?
Many thanks.
Hello,
I am trying to sort a range which contains number by having the blanks sorted out first. Is there a formula or vba solution to achieve this?
Many thanks.
Hi sans
maybe something like this
![]()
Sub ert() Dim i&, r As Range On Error Resume Next With Range("B5").CurrentRegion For Each r In .Rows i = r.SpecialCells(4).Count If Err Then Err.Clear Else r.Cells(1).Resize(, i).Insert xlShiftToRight Next r End With End Sub
Thanks for the reply nilem. The macro works great. For some reason when I run it in the attachment above it works as expected but when I run it in my normal document I get no activity. Can't figure out why. Many thanks!
Can the above be done with a formula? I need to use this function very often and a formula would be much faster to work with.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks