Pausing Macros

[hopp]

I'm trying to write a macro in which it copy and pastes cells from 1 sheet to another. However, as i have it now, i can only select 1 column at a time because im trying to make the macro's usable for any area in the sheet. Is there any way to specify a start point then have the macro increment to where you want? Or is there a way to pause the macro so you can specify different cells?

*sighs* i wish they just gave me c++ to work with.

thanks.

 

[xlbo]

You may use the SELECTION object to reference a set of cells you have selected

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[jgilbert]

In reference to your sigh, I believe OpenOffice gives you the ability to write macros in C++. I could be wrong, I know it allows Python and Java.

Joe