Search results 60

Sorted from new to old.

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

2019Jun12

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

2019Jan9

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

2018Aug16

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

2018Aug10

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

2018Jul5

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

2018Jul4

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

2018Jul4

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

2018Jul1

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

2018Jun24

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

2018Jun10

This is the final version of my set of Setting functions SettingRead, ...

2018Apr27