View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default Formatting within a Macro

please show us the macro code
It should be simplistic to add a couple of lines to do the emboldening and
lines


"KalliKay" wrote:

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.