Search results 60

Sorted from new to old.

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

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

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

NumberEnding

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

2023May3

ANmaDate

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

2023Apr27

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

1 2 3 4