LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Range 's top property clara Excel Programming 4 May 11th 07 10:00 PM
Use of Range Property Arnold Klapheck Excel Programming 5 August 28th 06 08:19 PM
VBA Range Property AndrewCrisp[_2_] Excel Programming 3 July 23rd 06 09:27 PM
range property of range object Woody[_3_] Excel Programming 1 June 23rd 05 09:04 PM
Row and Column from Used Range property?? C. Johnson Excel Programming 1 March 31st 05 07:51 PM


All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"