Search results 60

Sorted from new to old.

Hack VBE password in .xlsm

Remove VBE project password protection off of xlsm. This is screenshot on how ...

2025Dec30

ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

2025May16

ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

2025Apr19

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

2025Apr18

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

2025Feb19

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

2025Jan8

Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

2024Nov13

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

2024Mar12

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

2024Feb8

Int function in ASP Classic (cint vs fix)

If you are looking for a function ASP Classic (VBScript) to do what Int() does ...

2024Feb6

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

Thin HTML5 Coming soon Template

Simple, elegant, thin template for Under Contruction site. Found it in my ...

2023Aug19

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

1 2 3 4