Search results 140

Sorted from new to old.

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

Window and screen sizes in jQuery

Get the size of the screen, current web page and browser window using jQuery ...

2021Mar18

ASP to static HTML

Convert Dynamic ASP files into HTML (once daily) to make them faster when ...

2020Dec24

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

2020Dec21

FeeKey + UnFeeKey

Protect Numbers by encoding them into Alphabetic And convert them back ...

2020Nov11

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

File_SettingRead

Reads setting from config file Config file can be passed as argument ...

2020Sep23

URLDecode

Decodes a URL encoded string back into the original text. Similar to ...

2020Aug21

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

DelFiles

A very simple to delete a directory and the entire files and folders in its ...

2020Apr1

IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

Remove_Between2Quotes

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

2020Mar9

ShortenDir

Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...

2020Feb19

IsThere2

Finds a file in giving its full path Similar to IsThere1 except this one uses ...

2020Jan10

1 2 3 ...8 9