Search results 66

Sorted from new to old.

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

CutString9

Cuts from CutFrom starting from any of items found from ...

2024Jan7

Protect txt file into word doc with password

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

2024Jan4

CutString7

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

2024Jan1

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

1 2 3 4 5