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
Finds the location of a sting inside list of strings with certain separator, or ...
Tue 8AM
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...
Apr18
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Show or hide item (or items) in PivotTable for a certain field. Passing ...
Jan23
ASP based AJAX example to call mdb database using
2020Sep7