If there are blank cells in the first row of the selected range, you'll
see that error message.

Wally wrote:
When i try to make a pivot table I choose my data range and then I'm
told.

my pivot table field name isn't valid.... :(

What am I doing wrong?

Wally





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html