View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John S.[_3_] John S.[_3_] is offline
external usenet poster
 
Posts: 1
Default Setting TopMargin Property in VBA

Hi;
Is it possible to make Excel take the TopMargin value from
a variable or a cell. I tried a number of variations and
VBA keeps sending message: 'object does not support this
property or method'
e.g.
....
upmargin = Range("l2")
prtsheet.TopMargin = Application.InchesToPoints(upmargin)
....

Thanks.