Sub Macro1()
'
' Macro1 Macro
' Macro recorded 3/14/2006 by Dave
'
'
Range("A1:H13").Select
End Sub
or
Sub Macro2()
'
' Macro2 Macro
' Macro recorded 3/14/2006 by Dave
'
Range("A1").Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
End Sub
this starts at A1 and Ends at your last cell
--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile:
http://www.excelforum.com/member.php...o&userid=31708
View this thread:
http://www.excelforum.com/showthread...hreadid=522331