Assuming there will be data in column A for the last used row prior to 1000
and your data would never go all the way to row 999:
Rows.Hidden = false
set rng = cells(999,1).End(xlup)(2)
range(rng,cells(999,1)).Entirerow.Hidden = True
--
Regards,
Tom Ogilvy
"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