You should use the Macro Recorder from within Excel to figure this stuff out. Use Alt|Tools|Macros|RecordMacros... and then hit Alt+F11 to open up the IDE and find your code.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.