Thread: Need help setting the worksheet header/Footer margins based on string height?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Doug Doug is offline
external usenet poster
  
Posts: 4
Default Need help setting the worksheet header/Footer margins based on string height?
I was able to improve the results by adding the value of HeaderMargin
and FooterMargin to the strings height but it's sill not 100% perfect.

It's almost perfect for 1 or two lines but for 3 or more the
strHeight+HeaderMargin starts to get too big.

Anyone have any Ideas?

This is part of a macro to transform a set of cross tabs to charts.

Doug

Reply With QuoteReply With Quote