 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2005How to use variables for Range( ) ?
Lets say my starting and ending coordinate variables are (x1,y1) and (x2,y2). I want to define a Range from (x1,y1) to (x2,y2). Range( ) accepts string datatype so i cannot use variables in Range( ). I cannot use Cells ( ) cos it defines a single cell only. Sorry for bothering you, i guess this is the answer: Range(Cells(x1, y1), Cells(x2, y2)) "serdar" <serdarsoy@yahoo.com>, haber iletisinde þunlarý yazdý:#KWf5DpbFHA.2420@TK2MSFTNGP15.phx.gbl... > Lets say my starting and ending coordinate variables are (x1,y1) and > (x2,y2). > > I want to define a Range from (x1,y1) to (x2,y2). Range( ) accepts string > datatype so i cannot use variables in Range( ). I cannot use Cells ( ) cos > it defines a single cell only. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.