Working with Lists in Excel 2003
 

Hi All

I have 2 lists of numbers (say column A and column B) that have been
copied via macro to their current location. I wanted to add to this
macro so that column totals were inserted (on one row). My problem is
that the length of the data in both columns can vary each time the
macro's are run and there is no way of knowing in advance which column
will be the longest or on what row the last figure will fall.

Is there a relatively easy way (perhaps through keyboard shortcuts)
that I can work out what row to insert the totals on so that I am not
chopping off some data?

Thanks in advance

Karen


--
ksp
------------------------------------------------------------------------
ksp's Profile: http://www.excelforum.com/member.php...fo&userid=6267
View this thread: http://www.excelforum.com/showthread...hreadid=395240