Search results 104

  2. Search results
  3. functions
Sorted from new to old.
Card image
XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26
Card image
3D Progressbar

CSS-JS animated Progress bar. Was looking for pregressbar in svg, couldn't ...

2023Aug18
Card image
Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

2023Aug1
Card image
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11
Card image
ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5
Card image
ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23
Card image
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23
Card image
WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22
Card image
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18
Card image
NavigatePost

Reads content of webpage with optional post data two main differences from

2023Jan14
Card image
Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6
Card image
CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22
Card image
CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3
Card image
InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6
Card image
Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2
Card image
Frm81 - FullDetails

Show window of details, can be used to show content for certain cell, or show ...

2021Jun26
123...67