Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am following http://www.anthony-vba.kefra.com/vba/vbabasic2.htm to
spin up on Excel/VBA programming. Consider a case in which the Range keyword in the right-hand-side of an assignment. Most of the examples in this page show arguments supplied to Range to specify a matrix of cells on the spreadsheet. If one does not supply arguments, and merely accesses the Cells function: Range.Cells(2,5) does that mean Range defaults to the entire spreadsheet? Alternatively, is there a concept of "current/active Range", which might (for example) be the last Range used in an expression? If so, is this memory of the latest Range maintained on a worksheet-by- worksheet basis, or is there just one "current/active" Range? Do similar assumptions apply to a "current/active" WorkSheet? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Range 's top property | Excel Programming | |||
Use of Range Property | Excel Programming | |||
VBA Range Property | Excel Programming | |||
range property of range object | Excel Programming | |||
Row and Column from Used Range property?? | Excel Programming |