Search results 62

Sorted from new to old.

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

Cuts the left or Middle part of string without breaking words Can specify ...

2018Aug8

Removes comma between the first pair of quotations (RemoveCommaBetween2Quotes)

2018Jul24

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

2018Jul11

Converts RGB color to / from HTML format As bonus, functions RGB_ExtractColor ...

2018Jul9

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

Generates the calendar week number for a certain date, counting the first week ...

2018Jun26

Asks user before running a link (mostly before deleting) Small important part ...

2018Jun19

Reads binary file in chunks, if not chuck defined, all file will be red/saved ...

2018Jun18

Reversing a file This tip demonstrates how to reverse a whole file. This ...

2018Jun16

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

2018Jun11

Cuts the left part respecting words, without cutting words

2018May30