CT Calc will produce a shortcut macro
The macro follows the format:
&CT
where CT is the function for the
operation you are performing.
CT Calc will recognize “CT” when it is
used as an input.
If the operator you have entered
is not recognized, CT Calc will
attempt to fill in the missing
operator.
CT Calc will recognize:
“CT” for CT Calc in the first
place.
then any specified operator or
all operator(s) in order.
EXAMPLE:
Calc
CT var(x)
vld(x)
CT var(a)
var(a)
&CT x=a
CT 1=1
CT 1=0
CT atn(a)(a,b)
=b
CT vld(x)
=x
&CT
If you want to specify any
special operators (just like the
standard C language):
CT 1=1
CT a=b
CT c=d
CT &CT
If you want to select
multiple operator(s)
such as “=” and “>”:
CT var(x)
vld(x)
vld(y)
vld(z)
&CT x=y
&CT y=z
CT x=a
y=b
CT x=a
y=b
&CT
CT var(a)
vld(a)
&CT
Examle:
CT
CT a=b
CT 1=1
CT 1=0
CT atn(a)(a,b)
=b
CT vld(x)
=x
CT var(x)
vld(x)
&CT
CT var(a)
vld(a)
&CT
CT
CT
CT
If you want to specify
multiple operators
and their arguments:
CT var(x)
vld(x)
vld(y)
vld(z)
&CT x=y
&CT y=z
&CT z=x
CT var(a)
vld(a)
&CT
CT
CT
CT
If you want to apply
conditional functions:
CT a=2
CT 1=1
CT a=1
CT var 384a16bd22

Key Macro in Excel helps you to record your custom macro. Create your new macros with ease without having to make the difficult choice of whether to write a macro or not. And it’s all done within your Excel workbook.
Key Macro in Excel can be used to automate any Excel task. From creating a new workbook, to inserting text into a cell, to creating a drop down list from a range of values, to copying a sheet, Key Macro in Excel can do it all. A simple plug in, Key Macro in Excel makes macros more powerful and easier to use than ever before.
Do you want to create a Macro to automatically update your spreadsheet when a new row is added to your database? You can create your own macro to automate these tasks. With Key Macro in Excel, you can develop your own custom macros without having to learn programming languages like VBA.
Key Macro in Excel is an all-in-one plug in for Excel allowing you to quickly and easily create a wide range of macros to automate and customize Excel.
Key Macro in Excel allows you to:
* Automate all kinds of Excel tasks, including
* Set up the reference to all kind of Excel objects
* Automate any Excel action, even you want to copy a sheet to another workbook, create a new workbook, create a new sheet, insert text into a cell or go to a range of cell and copy values of this range
* Create your own formulas or customize them for your specific needs
* Set up macros to get data from database
* Record all macros on your Excel workbook
Key Macro in Excel can be used to create the following macros:
* Insert text in a cell
* Create a new worksheet
* Copy a sheet
* Copy a range of cells
* Select data from a database
* Select data from a database and get values from the column
Key Macro in Excel can be used to create the following formulas:
* Insert a simple formula, for example A1 = B1 + C1
* Insert a function, for example A1 = B1 + C1
* Set a formula to a range of cells
* Set a formula to multiple cells
* Find function of a range of cells
* Insert multiple formulas, for example A1 = B1 + C1 A2 = B2 + C2
* Find a range of

Categories: How To's