View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
waynehinds[_2_] waynehinds[_2_] is offline
external usenet poster
 
Posts: 1
Default Borders with Macros


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

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

--
waynehind
-----------------------------------------------------------------------
waynehinds's Profile: http://www.excelforum.com/member.php...fo&userid=2533
View this thread: http://www.excelforum.com/showthread.php?threadid=38811