Search results 14

Sorted from new to old.

Always found myself struggling when applying security to websites for the past ...

2024Nov7

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

Gets no of columns in an HTML table. It actually gets the maximum number of ...

2024Oct26

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

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

2023May11

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

2022Jan5

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

Compress a single file into zip archive using 7Za.exe 7za.exe (found in ...

2018Jul14