Hello Dave,

First let me say that Chip is one of the Excel GODs as far as I am concerned.

I thought he wanted to show that value assinged IN the Sub does not change...



"Dave Peterson" wrote:

I don't think so.

Chip is showing that that since Pub is declared outside any Sub/function, it
retains its value between calls to the subroutine.