Excel: Help writing a Macro that require a selection?

Greetings! I am at the very beginning stages of learning VBA, and I am a basic level excel user (I have messed with one or two formula's but nothing much). I am working on a project, and need to know if there is a way to write a macro that requires an on-screen (with a mouse) selection of the cells you want to apply the macro to? I would like to build a macro that completes multiple steps of a clean-up process quickly, however I need to be able to select different cells, and different columns, possibly in different workbooks to apply the macro to. This forum is famous for its knowledgeable feedback. I appreciate any help you can give me! Sincerely, -Meesha:biggrin:

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of April 04, 2015.

For more resources for Microsoft Excel