LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 593
Default Finding last row that is empty

poppy wrote ...

I want to be able to find the last empty row in a worksheet and work
out the totals of each column and place it in this row.


As you used SQL to fetch the data, I can tell you can use a query to
insert the total in Excel e.g.

INSERT INTO
[MySheet$B3:B65536]
(Price)
SELECT
SUM(Price) AS Price
FROM
[MySheet$B3:B65536]
;

Although in the above the maximum rows has been specified, in reality
the provider will find the next unused row and insert the total there.
However, a SQL insert can only be done on a closed workbook. Is this a
show-stopper for you?

For your original question about formatting, your sample data is all
over the place as I see it:

http://groups.google.com/groups?selm...rum-nospam.com

You may want to repost.

Jamie.

--
 
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
Finding the next empty cell. Unknown_User[_3_] Excel Programming 10 May 19th 04 02:45 PM
Finding last non-empty column in row... Mika[_3_] Excel Programming 2 November 11th 03 08:50 PM
Dynamically finding the last empty row Mike Potocki Excel Programming 3 October 17th 03 04:34 PM
Finding Empty Rows Tom Ogilvy Excel Programming 0 July 16th 03 04:54 PM
Finding Empty Rows Don Guillett[_4_] Excel Programming 0 July 16th 03 04:50 PM


All times are GMT +1. The time now is 08:24 PM.

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"