SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

Send page to print

JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

Web.config redirect

Redirect URLs to certain page passing its name. This is web.config from one of ...

web.config.zip

Zoomed iframe

Show iframe zoomed or in scale Thanks to

Fix Excel Issue

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

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

Excel user name

Get application user name or change it Originally from