View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.domaskis@gmail.com is offline
external usenet poster
 
Posts: 41
Default The Range property

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!