Posted to microsoft.public.excel.programming

Mia

external usenet poster

Posts: 101

Summary in the last row

Hi,

I'm need to make a vba macro where the macro automaticly shall find
the last row and make a summary of the total column D. I cant get
It right, can someone please help?

So far I only has typed following.

Dim lngLastRow As Long
lngLastRow = ActiveSheet.Cells(Rows.Count, "D").End(xlUp).Row
Range("D" & lngLastRow + 1) = _

--
Best regards
Mia

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
Copy two summary ranges to master summary sheet	a m spock	Excel Programming	5	September 13th 08 01:49 PM
multi group with summary above with 1 overall summary line below	Freddy	Excel Discussion (Misc queries)	2	November 7th 05 03:30 PM
multi group with summary above with 1 overall summary line below	Freddy	Excel Discussion (Misc queries)	1	November 1st 05 08:50 PM
Summary	[email protected]	Excel Worksheet Functions	2	February 2nd 05 05:46 AM
Summary Help	Michael168[_63_]	Excel Programming	0	November 13th 03 09:21 AM

All times are GMT +1. The time now is 07:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us