Search results 60

Sorted from new to old.

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jul29

Finds if a workbook is open or not in same Excel session

2018Jul11

Sorts a column in Excel, easily, with options Expects ... Row 1 is header, ...

2018Jul4

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

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

2018Jun26

Get a Number Suffix They allow you to turn 1 into 1st, 2 into 2nd, etc. giving ...

2018Jun24

Returns true if VBA is accessible through code, returns false if not

2018Jun22

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14

To encrypt or decrypt any string ' Strii is the required text to protect ' ...

2018Jun2

Converts R:G:B into RGB value (as long) and RGB from long into R:G:B

2018May30

Returns a formatted version of file 'LastModified' date. Pass parameter ...

2018Apr25

The subprocedure can be called by any ASP applicaiton/page which needs to ...

2018Apr14