Move selected row to top of range

gtd526

gtd526

Well-known Member
Joined
Jul 30, 2013
Messages
684
Office Version
  1. 2019
Platform
  1. Windows
Hello,
I'm able to select rows where E:E >= 70%, and F:F >= 10.
How can I insert the selection to the top of range? (ie Row 3)
Then the next move will be under the 1st move. 2nd under 1st, 3rd under 2nd, 4th under 3rd, etc until there are no more selections.
Here is the code for making the selections. Below the code is the worksheet.

VBA Code: 
Sub test()
'works
'select row if cells in 2 different columns meet criteria

    Dim i As Long
    Dim n As Long
    
    n = Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Row
    
    For i = 3 To n
        With Sheets("Sheet2")
            If Cells(i, 5) >= 0.7 And Cells(i, 6).Value >= 10 Then
                Cells(i, 5).Rows().EntireRow.Select   'Cut
                MsgBox "its selected"
            End If
        End With
    Next i
    MsgBox "Your Done"

End Sub


NBA.xlsm
ABCDEF
1Row 4Row 50.710
2As FAV As FAVRankCriteria2Criteria2 PercentageCount
3IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),ISNUMBER($R4),($R4>0),$R4>$R5,ISNUMBER($S4),($S4>0),$S4>$S5,ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"R, S, T>0, AL:AM>=60%"IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),ISNUMBER($R5),($R5>0),$R4<$R5,ISNUMBER($S5),($S5>0),$S4<$S5,ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"R, S, T>0, AL:AM>=60%"1R, S, T>0, AL:AM>=60%100.0%2
4,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$Q4>=$Q5,$S4>=$S5,ISNUMBER($T4),($T4>0),ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"Q, S, T>0, AL:AM>=60%",IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$Q4<=$Q5,$S4<=$S5,ISNUMBER($T5),($T5>0),ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"Q, S, T>0, AL:AM>=60%"1Q, S, T>0, AL:AM>=60%100.0%4
5,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$Q4>=$Q5,ISNUMBER($T4),($T4>0),ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"Q, T>0, AL:AM>=60%",IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$Q4<=$Q5,ISNUMBER($T5),($T5>0),ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"Q, T>0, AL:AM>=60%"1Q, T>0, AL:AM>=60%100.0%2
6,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$AM4>=$AM5),"Tovers (AD)",IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$AM4<=$AM5),"Tovers (AD)"1Tovers (AD)100.0%4
7,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$Q4>=$Q5,$R4>=$R5,ISNUMBER($T4),($T4>0),ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"Q, R, T>0, AL:AM>=60%",IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$Q4<=$Q5,$R4<=$R5,ISNUMBER($T5),($T5>0),ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"Q, R, T>0, AL:AM>=60%"1Q, R, T>0, AL:AM>=60%100.0%1
8,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),ISNUMBER($Q4),($Q4>0),$Q4>$Q5,ISNUMBER($R4),($R4>0),$R4>$R5,ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"Q, R, AL:AM>=60%",IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),ISNUMBER($Q5),($Q5>0),$Q4<$Q5,ISNUMBER($R5),($R5>0),$R4<$R5,ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"Q, R, AL:AM>=60%"6Q, R, AL:AM>=60%77.3%22
9,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$Q4>=$Q5,$S4>=$S5,ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"Q, S, AL:AM>=60%",IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$Q4<=$Q5,$S4<=$S5,ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"Q, S, AL:AM>=60%"6Q, S, AL:AM>=60%77.3%22
10,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"Rank2, AL:AM>=60%",IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"Rank2, AL:AM>=60%"8Rank2, AL:AM>=60%76.5%51
11,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$Q4>$Q5,$R4>0,$R4>$R5,$S4>0,$S4>$S5,ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"Q, R, S, AL:AM>=60%",IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$Q4<$Q5,$R5>0,$R4<$R5,$S5>0,$S4<$S5,ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"Q, R, S, AL:AM>=60%"9Q, R, S, AL:AM>=60%76.0%25
12,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$M4>=$M5,ISNUMBER($N4),($N4>0),$Q4>=$Q5,ISNUMBER($R4),($R4>0),ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"M,N>0,Q,R>0,AL:AM>=60%",IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$M4<=$M5,ISNUMBER($N5),($N5>0),$Q4<=$Q5,ISNUMBER($R5),($R5>0),ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"M,N>0,Q,R>0,AL:AM>=60%"10M,N>0,Q,R>0,AL:AM>=60%75.0%8
13,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$Q4>=$Q5,$R4>=$R5,$S4>=$S5,ISNUMBER($T4),($T4>0),ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"Q, R, S, T>0, AL:AM>=60%",IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$Q4<=$Q5,$R4<=$R5,$S4<=$S5,ISNUMBER($T5),($T5>0),ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"Q, R, S, T>0, AL:AM>=60%"11Q, R, S, T>0, AL:AM>=60%71.4%7
14,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$AH4>=$AH5),"EPR (AG)",IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$AH4<=$AH5),"EPR (AG)"11EPR (AG)71.4%7
15,IF(AND($A4=$AQ4,$B4<0,$K4<=$K5,ISNUMBER($Q4),($Q4>=0.55),ISNUMBER($R4),($R4>0),ISNUMBER($S4),($S4>0),$AR4=TRUE,$AW4<=$AW$1,$Q4>=.55,ISNA(MATCH($A4,$H$52:$H$66,0)),$O4>=$O5,ISNUMBER($AL4),($AL4>=.6),ISNUMBER($AM4),($AM4>=.6)),"MOV, AL:AM>=60%",IF(AND($A5=$AQ5,$B5<0,$K4>=$K5,ISNUMBER($Q5),($Q5>=0.55),ISNUMBER($R5),($R5>0),ISNUMBER($S5),($S5>0),$AR5=TRUE,$AW5<=$AW$1,$Q5>=.55,ISNA(MATCH($A5,$H$52:$H$66,0)),$O4<=$O5,ISNUMBER($AL5),($AL5>=.6),ISNUMBER($AM5),($AM5>=.6)),"MOV, AL:AM>=60%"13MOV, AL:AM>=60%71.2%52
16,IF(AND($A4=$AQ4,$B4<0,$B4=100),"????",""))))))))))))))))))))))))))),IF(AND($A4=$AQ4,$B4<0,$B4=100),"????","")))))))))))))))))))))))))))#VALUE!???? 
Indicators
Cell Formulas
RangeFormula
C3:C16C3=RANK(E3,Rank)
D3:D16D3=MID($A3,FIND("""",$A3)+1,FIND("""",$A3,FIND("""",$A3)+1)-FIND("""",$A3)-1)
E3:E16E3=IF($D3="????","",IF($D3="Rank2, AL:AM>=60%",Favs!$AH$55,IF($D3="MOV, AL:AM>=60%",Favs!$AB$67,IF($D3="MOV2, AL:AM>=60%",Favs!$AE$67,IF($D3="MOV,MOV2,AL:AM>=60%",Favs!$AH$67,IF($D3="M,N>0,Q,R>0,AL:AM>=60%",Favs!$Y$79,IF($D3="EPR (AG)",Favs!$M$91,IF($D3="MOV2 > ATS",Favs!$V$79,IF($D3="Tovers (AE)",Favs!$V$91,IF($D3="Steals (AE)",Favs!$Y$91,IF($D3="Rank2, AL>=60%",Favs!$AB$55,IF($D3="Fouls (AF)",Favs!$AB$91,IF($D3="Adj Off. (AH)",Favs!$AE$91,IF($D3="Adj Def. (AI)",Favs!$AH$91,IF($D3="Pts in Paint (AJ)",Favs!$P$91,IF($D3="MOV2, AL:AM>=60%",Favs!$M$103,IF($D3="M,N>0,Q,R>0,AL:AM>=60%",Favs!$Y$79,IF($D3="Pts in Paint (AJ)",Favs!$V$55,IF($D3="Q, R, S, AL:AM>=60%",Favs!$P$43,IF($D3="Poss/G (AC)",Favs!$S$91,IF($D3="Tovers (AM)",Favs!$V$91,IF($D3="Adj Off. (AQ)",Favs!$AE$91,IF($D3="Adj Def. (AR)",Favs!$AH$91,IF($D3="ToverS (AD)",Favs!$V$91,IF($D3="Q, R, S, T>0, AL:AM>=60%",Favs!$M$43,IF($D3="Q, R, T>0, AL:AM>=60%",Favs!$S$43,IF($D3="Q, S, T>0, AL:AM>=60%",Favs!$Y$43,IF($D3="R, S, T>0, AL:AM>=60%",Favs!$Y$43,IF($D3="Q, R, AL:AM>=60%",Favs!$P$55,IF($D3="Q, S, AL:AM>=60%",Favs!$S$55,IF($D3="Q, T>0, AL:AM>=60%",Favs!$M$67,"")))))))))))))))))))))))))))))))
F3F3=Favs!$Y$48
F4F4=Favs!$V$48
F5F5=Favs!$M$72
F6F6=Favs!$V$96
F7F7=Favs!$S$48
F8F8=Favs!$P$60
F9F9=Favs!$S$60
F10F10=Favs!$AH$60
F11F11=Favs!$P$48
F12F12=Favs!$Y$84
F13F13=Favs!$M$48
F14F14=Favs!$M$96
F15F15=Favs!$AB$72
Cells with Conditional Formatting
CellConditionCell FormatStop If True
C3:F34Expression=AND($E3>=0.7,$F3>=10,$E3<>"")textNO
D3:D34Cell ValueduplicatestextNO
D3:D34,L15:L64Cell ValueduplicatestextNO
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Sort by date Sort by votes
Try this on a copy.

VBA Code: 
Sub test()
    ' Select rows if cells in 2 different columns meet criteria
    Dim i As Long
    Dim n As Long
    Dim pasteRow As Long
 
    n = Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Row

    pasteRow = 3
   
    For i = 3 To n
        With Sheets("Sheet2")
            If .Cells(i, 5) >= 0.7 And .Cells(i, 6).Value >= 10 Then
                .Rows(i).Cut Destination:=.Rows(pasteRow)
                pasteRow = pasteRow + 1
            End If
        End With
    Next i
   
    MsgBox "You're Done"
End Sub
 
Upvote 0
Cubist said:
Try this on a copy.

VBA Code: 
Sub test()
    ' Select rows if cells in 2 different columns meet criteria
    Dim i As Long
    Dim n As Long
    Dim pasteRow As Long
 
    n = Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Row

    pasteRow = 3
  
    For i = 3 To n
        With Sheets("Sheet2")
            If .Cells(i, 5) >= 0.7 And .Cells(i, 6).Value >= 10 Then
                .Rows(i).Cut Destination:=.Rows(pasteRow)
                pasteRow = pasteRow + 1
            End If
        End With
    Next i
  
    MsgBox "You're Done"
End Sub
Click to expand...
I've tested and its overriding the row where its pasted.
Can we have Cut rows Inserted not Pasted? This way no rows are missing, everything will be there but in a different order.
 
Upvote 0
Misread what you wanted. Try this...
VBA Code: 
Sub test()
    ' Cut and insert rows if cells in 2 different columns meet criteria
    Dim i As Long
    Dim n As Long
    Dim insertRow As Long
    n = Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Row
    
    insertRow = 3
    For i = 3 To n
        With Sheets("Sheet2")
            If .Cells(i, 5) >= 0.7 And .Cells(i, 6).Value >= 10 Then
                .Rows(i).Cut
                .Rows(insertRow).Insert Shift:=xlDown
                insertRow = insertRow + 1
            End If
        End With
    Next i
    MsgBox "You're Done"
End Sub
 
Upvote 0
This has an additional error handle when the cut rows aren't the same size.

VBA Code: 
Sub test()

    Dim i As Long
    Dim n As Long
    Dim insertRow As Long
    n = Sheets("Sheet2").Cells(Rows.Count, 3).End(xlUp).Row
    insertRow = 3
    For i = 3 To n
        With Sheets("Sheet2")
            If .Cells(i, 5) >= 0.7 And .Cells(i, 6).Value >= 10 Then
                .Rows(i).Copy
                .Rows(insertRow).Insert Shift:=xlDown
                .Rows(i + 1).Delete
                insertRow = insertRow + 1
            End If
        End With
    Next i
    Application.CutCopyMode = False
    MsgBox "You're Done"
End Sub
 
Upvote 0
Solution
Cubist said:
Misread what you wanted. Try this...
VBA Code: 
Sub test()
    ' Cut and insert rows if cells in 2 different columns meet criteria
    Dim i As Long
    Dim n As Long
    Dim insertRow As Long
    n = Sheets("Sheet2").Cells(Rows.Count, 1).End(xlUp).Row
   
    insertRow = 3
    For i = 3 To n
        With Sheets("Sheet2")
            If .Cells(i, 5) >= 0.7 And .Cells(i, 6).Value >= 10 Then
                .Rows(i).Cut
                .Rows(insertRow).Insert Shift:=xlDown
                insertRow = insertRow + 1
            End If
        End With
    Next i
    MsgBox "You're Done"
End Sub
Click to expand...
Perfect. Thank you.
 
Upvote 0
Cubist said:
This has an additional error handle when the cut rows aren't the same size.

VBA Code: 
Sub test()

    Dim i As Long
    Dim n As Long
    Dim insertRow As Long
    n = Sheets("Sheet2").Cells(Rows.Count, 3).End(xlUp).Row
    insertRow = 3
    For i = 3 To n
        With Sheets("Sheet2")
            If .Cells(i, 5) >= 0.7 And .Cells(i, 6).Value >= 10 Then
                .Rows(i).Copy
                .Rows(insertRow).Insert Shift:=xlDown
                .Rows(i + 1).Delete
                insertRow = insertRow + 1
            End If
        End With
    Next i
    Application.CutCopyMode = False
    MsgBox "You're Done"
End Sub
Click to expand...
Thank you for the update. I ran into errors, then reviewed our posts and saw your solution.
Is the error due to the top pick is already at the top of the list?
 
Upvote 0
You must log in or register to reply here.

Similar threads

gtd526
  • Question Question
macro to add correct number of ")" at end of nested IF statement
Replies
1
Views
305
gtd526
gtd526
gtd526
  • Question Question
convert cell value to formula
Replies
8
Views
360
Fluff
Fluff
gtd526
  • Question Question
vba Sorting Columns w/ 2 Criteria's
Replies
1
Views
329
gtd526
gtd526
gtd526
  • Question Question
vba selecting a specific range if ISNUMBER
Replies
1
Views
357
gtd526
gtd526
gtd526
  • Solved
vba replace the first 3 characters - (NBA indicators)
Replies
1
Views
464
gtd526
gtd526

Forum statistics

Threads
1,223,872
Messages
6,175,104
Members
452,613
Latest member
amorehouse

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top