Similar codes

Card image cap
Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

2019Apr3

Card image cap
Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

Card image cap
strUnQuote

This will tests to see if strQuotedString is wrapped in quotation marks, and, ...

2018Jul3

Card image cap
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

Card image cap
CellSave_Hyperlink

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

2018Aug9

Card image cap
ProtectString + UnProtectString

Protects or unprotects a string giving a password Using XorD and similar to ...

2020Jan10

Card image cap
SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

Card image cap
Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

2019Apr25

Card image cap
ProtectText + UnProtectText

Encrypt or decrypt text, simple encryption with a numeric password Decrypt a ...

2018Jul19

Recently by developer

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

Card image cap
Files_FoundHours

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

Tue 7AM

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Mon 9AM

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

Random Codes

Card image cap
SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

Card image cap
ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

Jan15

Card image cap
IsEven + IsOdd

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

2018Sep27

Card image cap
HaveNonEnglish + StringASCIIs

Checks if one char is within two ASCII codes or not (StringASCIIs) Used to see ...

2018Jun17