Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range concepts
HI
Can any one guide me or provide some URL or link or doc to learn the following concepts. xlup,xldown, xlformulas,xlwhole ,xlnext,xlbycolumns and xlformulas etc. I am new to excel programming. Regards, Satyam Reddy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range concepts
From an Excel worksheet key Alt + F11 to get into the VBE. From there click
the Help button and select Microsoft Visual Basic Help then just type in the word you want. HTH Geoff "Satyam Reddy" wrote: HI Can any one guide me or provide some URL or link or doc to learn the following concepts. xlup,xldown, xlformulas,xlwhole ,xlnext,xlbycolumns and xlformulas etc. I am new to excel programming. Regards, Satyam Reddy |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range concepts
The examples you gave are Excel constants. There is not one place that you
can find the values of these constants and how they are used within the Excel or VBA help facilities. You can find a complete listing of them in the VBA help files by typing Microsoft Excel Constants in the VBA help search box and press enter. Then click on the same term to bring up a listing of the xlConstants. You can then open the Object browser and search for the class and member relationships of the constants. There is no easy way in the Application facilities to get what you are looking for. The alternative is to shell out about forty bucks for a book on VBA programming. "Satyam Reddy" wrote: HI Can any one guide me or provide some URL or link or doc to learn the following concepts. xlup,xldown, xlformulas,xlwhole ,xlnext,xlbycolumns and xlformulas etc. I am new to excel programming. Regards, Satyam Reddy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What are the most important Excel concepts I should know (will be tested soon)? | Excel Discussion (Misc queries) | |||
Summarizing concepts | Excel Discussion (Misc queries) | |||
How do I enter formula sum(range+range)*0.15 sumif(range=3) | Excel Discussion (Misc queries) | |||
What are the most important Excel concepts I should know (will be tested soon)? | Excel Discussion (Misc queries) | |||
FORMULA CONCEPTS | Excel Worksheet Functions |