Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...
2018Aug9
Searches for an item in a column, then if found, delete that cell (not clear, ...
2018Jun17
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Give users ability to multi-select from list of items into cells with separator. ...
2021Jun23
Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...
2020Oct31
Saves value to cell without deformation and converting Used to be called ...
2018Jun26
Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...
2018Jun15
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
I hate it when Windows forcing us to have additional items in "This PC" So, I ...
Feb5
Shows or hides an item or items in a PivotTable filter field. Passing ...
Jan22