K
ksp
Hi All
I have 2 lists of numbers (say column A and column B) that have bee
copied via macro to their current location. I wanted to add to thi
macro so that column totals were inserted (on one row). My problem i
that the length of the data in both columns can vary each time th
macro's are run and there is no way of knowing in advance which colum
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 no
chopping off some data?
Thanks in advance
Kare
I have 2 lists of numbers (say column A and column B) that have bee
copied via macro to their current location. I wanted to add to thi
macro so that column totals were inserted (on one row). My problem i
that the length of the data in both columns can vary each time th
macro's are run and there is no way of knowing in advance which colum
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 no
chopping off some data?
Thanks in advance
Kare