Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
a few simple newbies questions
Hello out there,
I am just getting into seriously editing my makros in VBA and I encounter a few things I'd like to know and which must be easy answers for those who know. 1. if I pass an object, say a worksheet to a sub-routine will it be passed by value or will it be passed by reference. What I want to know: If I make changes on that passed worksheet will they be there in the routine that called and passed the sub-routine? My guess: pass by reference. 2. Where is a good place to look up all I need to know about functions and subs, about objects, their methods and attribs in VBA? Where can I read about returned values and arguments? I can't believe the object catalog is the best I can get.... 3. How do I place a formula in a cell? Thanks so far Marco |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Questions should be simple please help | Excel Worksheet Functions | |||
Complex lookup task for a newbies | Excel Worksheet Functions | |||
Simple Questions | Excel Programming | |||
Several simple questions | Excel Programming | |||
Simple VB and Excel questions | Excel Programming |