Search results 222

  2. Search results
  3. add
Sorted from new to old.
Card image
DateOffset_FromMMDD

Calculate the new MMDD from a date formated as MMDD after adding/subtracting ...

Thu 8AM
Card image
ANmaFormatLastRow

Format last row found/added in Excel range to certain color. ColorText is the ...

Mar26
Card image
Hack VBE password in .xlsm

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

2025Dec30
Card image
RangeTakePicture_Linked

Converts a range in Excel sheet into picture. linked or unlinked. Important! ...

2025Sep30
Card image
ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

2025Sep30
Card image
ShapeDelete

Safely remove certain shape from worksheet

2025Sep30
Card image
Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

2025Jun30
Card image
Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

2025May27
Card image
BoldCodeColor

Bold the first letter and color it based on Bootstrap color theme, info, ...

2025May26
Card image
HTML_CountTags

Counts how many certain tag found in an HTML block. like how many tr found in ...

2025May16
Card image
UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

2025May12
Card image
1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

2025May12
Card image
Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

2025May11
Card image
MathInsideText

Return string after applying math to each number found inside the string. ...

2025May8
Card image
ANmaNotMatch

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

2025Apr19
Card image
FirstDuplicatedItem

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

2025Apr18
12...1314