Search results 71

Sorted from new to old.

End ( xlDown )

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

2023Aug28

Send page to print

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

2023Aug11

Total14Round

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

2023Aug8

Fix Excel Issue

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

2023Aug1

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

fNMRPrgs, Full-form progress bar (frm77)

Show progress bar inside userform, with option to control lots of things. This ...

2021Oct5

ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

2021Aug3

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

1 2 3 4 5