LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Q) Last row/column ------ excel formula query

Kindly suggest what is the best way to reference the following in excel formulas:
+) last row of a worksheet that has some data
+) last column of a worksheet that has some data

Regards,
Sandeep
 
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
Fill column adjacent to external query (Excel 2007) Andi Excel Discussion (Misc queries) 0 May 4th 09 08:24 PM
How do I expand formula down a column when query results change? ssciarrino Excel Discussion (Misc queries) 4 April 17th 09 01:26 AM
Dynamic URL for first column of data from excel query? Edgeline Excel Discussion (Misc queries) 1 October 8th 07 12:11 PM
Dynamic URL for first column of data from excel query? Edgeline Excel Discussion (Misc queries) 0 October 8th 07 03:29 AM
Converting an Excel formula to an Access query formula Adam Excel Discussion (Misc queries) 1 December 15th 04 03:38 AM


All times are GMT +1. The time now is 06:51 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"