Dave:

You're absolutely right. I have used that method of recording a macro then
looking at the code in the past and I'm not sure why I didn't think of it
this time.

Is it Friday, yet? :-)

Thanks!

"davegb" wrote:

Kevin,
Another easy way to find this kind of information out is to record a
simple macro. I just did a "Tools, Macro, Record new macro", typed in
Zoom for the name, then zoomed to a couple of different settings and
stopped recording. Then I went to the VBA editor and there was the code.