Try Debra Dalgleish's page at:

http://www.contextures.com/xlDataEntry02.html

Fill Blank Cells

Fill Blank Cells Programmatically*

[*Sub FillColBlanks()
'by Dave Peterson 2004-01-06]

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Jason" wrote in message
...
Hi,

In a pivot table, I have 2 fields in the row section.
How can I have the value on the first fields to repeat in every row
instead
of just showing once?

Thanks!!