 |
 | 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 / January 2008Use calculated cell as part of range reference
I have the following - Sheets("Search Rounds").Range("H8:AD10000").ClearContents which does the job but runs very slowly. I have in cell H6 the following - =COUNTA(H8:H10000) How can I incorporate the value from H6 into ("H8:AD10000") to give the actual populated range that I want to clear? I understand there is also a way using End(xlup) - I think!? - and if so which would be faster to process? Thanks Sandy Why not use a defined name? Insert>name>define>name it myrng>in the refers to box type =OFFSET($H$7,1,0,COUNTA($H:$H)-7,23) Now the range will be self adjusting based on the last row in col H >I have the following - > [quoted text clipped - 14 lines] > Thanks > Sandy Excellent solution Don. Thank you Sandy > Why not use a defined name? Insert>name>define>name it myrng>in the refers > to box type [quoted text clipped - 19 lines] >> Thanks >> Sandy Glad you like it > Excellent solution Don. > Thank you [quoted text clipped - 23 lines] >>> Thanks >>> Sandy
|
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.