Check these out

MsgBox ActiveSheet.UsedRange.Address
=============================
Dim LASTROW As Integer, rng as Range

LASTROW = Cells(Rows.COUNT, "A").End(xlUp).Row
set rng = Range("A1:AC" & LASTROW)
--
steveB

Remove "AYN" from email to respond
"waynehinds" wrote
in message ...

I would like to put a border around data using a macro. In some cases I
may need to border A1:AC44 and in other cases it may be A1:AC45. In all
cases the A1 is static and AC is static but the row is determined by
where the field 'Grand Total' is located.

How do i create a relative reference to put a border around this
information.


--
waynehinds
------------------------------------------------------------------------
waynehinds's Profile:
http://www.excelforum.com/member.php...o&userid=25331
View this thread: http://www.excelforum.com/showthread...hreadid=388111