View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default automatically update pivot tables when dynamic named range is

You're welcome, and thanks for posting back to say that you got it working.

Dave F wrote:
Well, I just figured it out. Turns out, Debra, you were right to ask me what
the last column I entered a value in is, as opposed to the last column that
calculates a value. Changing the 9 to an 8 fixed the problem.

Thanks to both of you. I'm not really sure what this code does, but it
works, so now the task for me is to figure it out.

Thanks again.

Dave



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html