View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KalliKay KalliKay is offline
external usenet poster
 
Posts: 18
Default Formatting within a Macro

I have the following reporting columns:

Prop# Owner Entity Prop Name Rentable SqFt Pkg Spaces

100-0001 OWNER1 PROP1 1,000 50
100-0002 OWNER1 PROP2 2,000 0
100-0003 OWNER1 PROP3 3,000 100

100-0004 OWNER2 PROP1 4,000 25
100-0005 OWNER2 PROP2 5,000 75

100-0006 OWNER3 PROP1 6,000 0

From within an Excel macro I am subtotalling the Rentable SqFt and Pkg Spaces
when the Owner Entity changes. What I need to know now is how to incorporate
double underlining and bolding the subtotals only.

Thanks.