View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ka2cil ka2cil is offline
external usenet poster
 
Posts: 7
Default Adding spaces to report title

Hi, I have a report with 4 lines of title which are centered & span over 12
columns. The first line contains a report number and rundate; separated only
by a single space. I would like to have the report number on the far left
(left justify) and the rundate on the far right (right justify). Any easy
way to add LOTS of spaces between these 2 fields? There are 100+ pages in
the report, therefore, a macro would be helpful. TIA!