Move selected row to top of range

gtd526

gtd526

Well-known Member
Joined
Jul 30, 2013
Messages
657
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

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
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
macro to add correct number of ")" at end of nested IF statement
Replies
1
Views
129
gtd526
gtd526
gtd526
  • Question
convert cell value to formula
Replies
8
Views
177
Fluff
Fluff
gtd526
  • Question
vba Sorting Columns w/ 2 Criteria's
Replies
1
Views
138
gtd526
gtd526
gtd526
  • Question
vba selecting a specific range if ISNUMBER
Replies
1
Views
160
gtd526
gtd526
gtd526
  • Solved
vba replace the first 3 characters - (NBA indicators)
Replies
1
Views
289
gtd526
gtd526

Forum statistics

Threads
1,215,069
Messages
6,122,954
Members
449,095
Latest member
nmaske

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