Posted to microsoft.public.excel.programming

Slim Slender[_2_] Slim Slender[_2_] is offline

external usenet poster

Posts: 39

Format a PivotTable

I am trying to:
Loop through cells in Column A
If the cell is empty then
format the cells from 1 cell to the right to count of used cells
to the right with a line on top
go to next cell
do until cell equals "Grand Total"

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Getting rid of PivotTable format	MichaelRobert	Excel Worksheet Functions	1	February 12th 09 06:17 PM
Format PivotTable from VBA out of MS Access	hannes	Excel Programming	0	November 4th 08 02:23 PM
Format PivotTable	PeterM	Excel Discussion (Misc queries)	1	August 13th 08 05:43 PM
PivotTable - cell format	Epinn	New Users to Excel	0	August 24th 06 08:45 PM
how can i do a conditional format in a PivotTable?	Hector	Excel Worksheet Functions	0	January 6th 06 05:52 PM

All times are GMT +1. The time now is 07:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us