Posted to microsoft.public.excel.programming

Pierre[_16_] Pierre[_16_] is offline

external usenet poster

Posts: 11

sum on a variable range

Hi all,

I have a macro that open a form

The user fill an excel sheet with this form

So i have a growing number of lines in the excel sheet.

I just want to sum colum D from the second line up to the end
and display the total on the form each time a line is created on the excel
sheet

How can i do that?

regards,

Pierre

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Variable Range	James C.	Excel Discussion (Misc queries)	3	April 2nd 09 12:41 AM
from Range variable	Marina Limeira	Charts and Charting in Excel	0	January 22nd 06 02:35 PM
Using a variable in a range	Tempy	Excel Programming	5	May 20th 05 08:54 PM
setting a range variable equal to the value of a string variable	Pilgrim	Excel Programming	2	July 1st 04 11:32 PM
Problem trying to us a range variable as an array variable	TBA[_2_]	Excel Programming	4	September 27th 03 02:56 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us