View Single Post
 
Old 07-29-2013, 06:29 PM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Seems to me the best way to start, if you don't already know VBA, is to start recording a macro; then do all the actions you want included, while the recording mechanism "watches". When you're done, stop recording, and look at the macro that Excel created. You'll have to modify it from there to make it more general; we'll have to talk about that.

I expect you'll have questions. Do you know how to record a macro? Once you've recorded a macro, do you know how to find and display it? And once you're looking at the macro instructions, do you have any programming background that will help you understand how it works?
Reply With Quote