Search results 64

Sorted from new to old.

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

2025Aug7

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

2025Jul27

ANmAraDate

Format full date in Arabic language using several known Arabic month syntax. ...

2025Jun12

PDFDoc - create PDF in ASP Classic

Create PDF in ASP Classic From

2025May27

ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

2025Feb2

Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

2025Feb2

PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

2025Feb1

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

2024Jul26

QuarterNumber_FromDate

Returns the number of quarter from a date

2024Jul26

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

2024Jul2

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

2024Mar23

1 2 3 4