Search results 632

Sorted from new to old.

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

Column1Range

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

2023Oct7

USB format in Android

What is the best format to use a USB storage for using in Android phones and ...

2023Sep28

Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20

SqlExec

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

2023Sep3

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

NumberFoundinsideTag

Checks if a number found between two characters, searching can be customized to ...

2023Aug21

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

Arr_1Dim_2Str

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

2023Aug14

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

WorkbookSave_ANmar

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

2023Aug9

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

Web.config redirect

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

2023Aug5

1 2 ...11 ...39 40