Debra,

If you record a macro as I said earlier, you can either merge this code into
that, or call the new macro from your old code.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"debra2468 " wrote in message
...
hey bob,
i already have a macro which is doing a lot of other things..in this
macro,i need to incorporate this code...

a) sort column K, which contains positive and negative values, in
ascending order..

b) display the grand totals of the positive and negative values by
inserting rows and then bold these totals....

how can i accomplish this ?


---
Message posted from http://www.ExcelForum.com/