Search results 60

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

RangeTakePicture_Linked

Converts a range in Excel sheet into picture. linked or unlinked. Important! ...

2025Sep30

ANmAraDate

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

2025Jun12

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

2025May25

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

2025May12

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

2025May12

ToggleCells

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

2025Feb2

PrevWeekday

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

2025Feb1

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

QuarterNumber_FromDate

Returns the number of quarter from a date

2024Jul26

Q_NoOfdays

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

2024Jun9

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

2024Mar3

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25

UnUnixDateTime

Convert a number represents a date in Unix format back into date, opposite of ...

2024Jan6

1 2 3 4