Search results 184

Sorted from new to old.

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

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

HTML2Str

Special version to convert HTML to string. Uses RemoveHTML, then after that it ...

2023Nov5

BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

End ( xlDown )

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

2023Aug28

Arr_1Dim_2Str

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

2023Aug14

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

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

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

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

1 2 ...4 ...11 12