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