Search results 86

  2. Search results
  3. range
Sorted from new to old.
Card image
Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14
Card image
Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22
Card image
CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

2019Aug1
Card image
Date range picker

Bootstrap date range picker From

2019Jul31
Card image
MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12
Card image
DialChart - Excel-VBA

A dial chart inside Excel using VBA code. With options to show 3 areas and two ...

2019Apr27
Card image
UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16
Card image
User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9
Card image
ChartMaxY + ChartMinY

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

2018Aug16
Card image
CopyRange_NoClipboard

Copies range without using clipboard. Applies formats into a cell (or range) ...

2018Aug10
Card image
UnBreakAr + BreakAr

Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...

2018Jul25
Card image
CutString1

Cuts a string from a string starting from a specific character index and until ...

2018Jul11
Card image
SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5
Card image
SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4
Card image
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4
Card image
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24
12...56