VBA Check if a sheet has any data validation

VisualBasic |

820 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

' ----------------------------------------------------------------
' Purpose: Function to check if a sheet contains any data validation
' ----------------------------------------------------------------
Function F_sheetHasDataValidation(sh As Worksheet) As Boolean
 
    Dim dataValRange As Range
 
    'Trying to assign data validation cells to a range object, if there is no data validation cells on
    'the sheet dataValRange remains Nothing
    On Error Resume Next
    Set dataValRange = sh.Cells.SpecialCells(xlCellTypeAllValidation)
    On Error GoTo 0
 
    'If dataValRange is Nothing there is no data validation cell on the sheet
    If dataValRange Is Nothing Then
        F_sheetHasDataValidation = False
    Else
        F_sheetHasDataValidation = True
        Set dataValRange = Nothing
    End If
 
End Function

Comments

CSS |

0 B

0 👍

0 👎

Raw Download Clone Embed Print View

✅ Leaked Exploit Documentation:
 
https://docs.google.com/document/d/1dOCZEHS5JtM51RITOJzbS4o3hZ-__wTTRXQkV1MexNQ/edit?usp=sharing
 
This made me $13,000 in 2 days.
 
Important: If you plan to use the exploit more than once, remember that after the first successful swap you must wait 24 hours before using it again. Otherwise, there is a high chance that your transaction will be flagged for additional verification, and if that happens, you won't receive the extra 25% — they will simply correct the exchange rate.
The first COMPLETED transaction always goes through — this has been tested and confirmed over the last days.
 
Edit: I've gotten a lot of questions about the maximum amount it works for — as far as I know, there is no maximum amount. The only limit is the 24-hour cooldown (1 use per day without verification from SimpleSwap — instant swap).

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎

Pasted

VBA Check if a sheet has any data validation

Comments