Search results 342

Sorted from new to old.

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

3D Progressbar

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

2023Aug18

SheetTabColor

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

2023Aug17

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

ListPivotsInfo

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

2023Aug13

Send page to print

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

2023Aug11

CopyDynamicRangeValue

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

2023Aug10

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

2023Aug9

Web.config redirect

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

2023Aug5

Fix Excel Issue

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

2023Aug1

CreditCardType

Returns credit card type and whether it is valid or not. Found it in my old ...

2023Jul28

Dark bootstrap5 css

Css and scss for dark Bootstrap 5 theme Made using

2023Jul26

O365 Blocked Macros

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

2023Jul10

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

1 2 ...5 ...21 22