Search results 61

Sorted from new to old.
Card image
Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

Card image
NumberEnding

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

Card image
ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

Card image
Progress in two nested loops

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

Card image
ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

Card image
DynamicFill

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

Card image
OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

Card image
RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

Card image
404 page

A nice simple 404 page with a game From

Card image
Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

Card image
AN_SafeFileName

Clean filename from special characters to make it safe for server upload Then ...

Card image
Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

Card image
Bootstrap full calendar

Full, simple and powerful, with AJAX, and template systems From

Card image
Bootstrap DateTime Picker

Date-Time picker in Bootstrap and Material Design

Card image
Char(39) in SQL table

One of many ways to go around the issue of char 39 in SQL database