Random codes

Similar codes

FindName

Finds a name in a workbook, returns true or false

2018Jun10

ANmarAmdeen

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6

ANmarAmdeen

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

Jul24

ANmarAmdeen

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

ANmarAmdeen

IsEven + IsOdd

Returns True if integer is even by using IsEven While IsOdd, will returns True ...

2018Sep27

ANmarAmdeen

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

Nov22

ANmarAmdeen

CTRL+K,C

Comment and de-comment lines quickly in VBE Create shortcuts inside VBE to ...

2019Jan5

ANmarAmdeen

FrmPass

Prompt for a password, or username and password, returns information back to ...

2018May20

ANmarAmdeen

DigitsORLettersOnly

Check if the string has special characters or not, only Letters or digits ...

2018Aug8

ANmarAmdeen

Recently by developer

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table.

Thu 3PM

ANmarAmdeen

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

ANmarAmdeen

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

ANmarAmdeen

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

Feb5

ANmarAmdeen

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

Dec27

ANmarAmdeen

Simple Captcha

Sometimes the simplest methods is the most powerful. That is what I said

2018Dec27

ANmarAmdeen

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

ANmarAmdeen