Simon, you could set your data up as a data list which would not require any
code to get you want you want. First, highlight all the data in your sheet.
Then, click DataListCreate list. Indicate if your highlighted list
includes a header. Once the list is created, you can toggle a totals row on
or off from the data list toolbar (which will appear whenever you click in
the list). The list will automatically expand as you add new data items.


"Simon Lloyd" wrote:


Hi all, I have an accounts sheet where row 1000 has all the sum totals,
is there anyway of getting this to be a floating row? i.e showing under
the last row used, or can i get all rows with no data in them between
the last used row (that contains data as the cells are already
formatted...borders etc.) and row 1000 to hide i can use an autoshape
or Cmd button for that, just need to know how to do it!

Hope you can help,

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=551964