Search results 64

Sorted from new to old.

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

Jan4

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Jan1

SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12

Nearby Color shades

Calculate colors close to input color, a jquery html that will give you 10 ...

2023Nov8

Column1Range

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

2023Oct7

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

1 2 3 4