Thread: macro
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
d_kight
 
Posts: n/a
Default macro

OK How about this error:
I have tried an example of using a macro to find the area of rectangle. I
made a function called area and here is the syntax I used in the Module:
Function Area(Length as Double, Width as Double)
Area = Length * Width
End Function

Then when I go to a worksheet, and place 17 in cell A1 and 10 in cell B1 and
in C1 type in =Area(A1,B1) I expect to get 170, but I get 0

Am I missing something??
Please help.
Dan

"CLR" wrote:

Check out these sites as a good place to start.........
www.cpearson.com
http://www.mcgimpsey.com/excel/index.html#usingvba
http://www.mvps.org/dmcritchie/excel/excel.htm

hth
Vaya con Dios,
Chuck, CABGx3



"d_kight" wrote:

I am pretty new to using (or attempting to use) a Macro in a workbook. I am
having trouble following how and what to do to even start the process; ie If
there needs to be a worksheet already in progress or can I start from a new
sheet.
THEN where to go from there.
Can I have some help in this area? Can some one supply me with a sample
MACRO?

Any help would be greatly appreciated

Dan