If you mean VBA code, turn on the macro recorder (Tools | Macro
record new macro...) do whatever it is you want through the GUI, turn
off the recorder, and switch to the VBE. In most cases, XL will give
you the necessary code.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I am looking for a very simple piece of code illustrating the format for a
"3D" range ie one that spans more than one worksheet. Can anyone help. the MS
help function is utterly useless. Thanks