. Add JMT Functions To Workbook

  Add JMT Functions to the active workbook.

  . Functions include -

• HASFORMULA 

• GETFORMULA

• GETFORMAT

• GETFONT

• GETCOMMENT

• SHEETSNAME

• BOOKSNAME

• FULLNAME

• USERSNAME

• PATHNAME

• ROWSIZE

• COLUMNSIZE

• FIRSTINROW

• FIRSTINCOLUMN

• LASTINROW

• LASTINCOLUMN

• MILLIONS

• THOUSANDS

• GETNUMBERS

• GETTEXT

• HASTEXT

• REVERSETEXT

• MAKEPASSWORD

• GETCOLORINDEX

• GETTHEMECOLOR *

• GETTINTANDSHADE *

• GETFONTINDEX

• COLORNAME

• GETHTMLCOLOR

• GETRGBCOLOR

• COUNTCOLOR

• SUMCOLOR

• DATEFORMAT

• DATEFORMAT2

• EDATEPLUS

• EOMONTHPLUS

• LASTDATE

• STATRAND

• STATRANDBETWEEN

• CHAIN

        * For Excel 2007 only

Back to download page