Define Macro

[Timmy]

1. Within a cell the simple calcualtion (5+5) or (10-2)

2. Within multiple cells along with custom formula
((cellA1+cellB1)/celld1)

If the above formula is entered into cell E1, will it be
caterogrized as Macro? Describe in detail what are the
criteria for Macro Classification.

 

[Norman Harker]

Hi Timmy!

Define Macro?

In Excel terms

How about:

"A Visual Basic for Applications subroutine."

What you described was a formula.

Probably your best bet would be to refer to texts that include
introductory coverage of VBA programming and here one of the most
common recommendations is John Walkenbach's Excel 97 (or 2000 or 2002)
Bible. Or do a search in a good bookshop, Amazon.com or see the
currently available texts maintained by Debra Dalgleish at:

http://contextures.com/xlbooks.html



--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Monday 14th July: France, French Guinea,
French Polynesia, Guadeloupe, New Caledonia, St Martin, and St. Pierre
& Miquelon (Bastille Day); Iraq, Martinique and Mayotte (National
Days); Madagascar (Fandoana Bathing Festival); Sweden (Crown Princess'
Birthday);Turkmenistan (Turkment Bakhsi Holiday); United Kingdom
(Emmeline Pankhurst Day). O-Bon / Festival of Souls (Shinto); NYT of
14-Jul-2003 reports 14-Jul National day has been abolished.
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Don Guillett]

=5+5
=10+2
=(a1+b1)/d1

These are formulas, not macros