general question about macro behaviour

[tomekm]

Hi,

If I create a macro and run it on a file (script would entail some vlookups to repository files, text-to-columns, etc.), do I have to re-run that macro every time I add information to the existing file and save it (added information with the same format, column names, etc.), or can I program the macro so that it applies the changes to all the cells in a tab automatically, regardless if there's info on them or not yet.

Thanks.

 

[Carpaccio]

Hi tomekm

Your macro is a program that runs and does something, when it stops, it's gone.

It may have written out information to workbooks or worksheets and that will remain.

If what remains is OK you don't need to run your macro again. If it needs updating, you run the macro again.

When in doubt, you run the macro again.

Yes, you can make changes to all the cells in a tab (worksheet) even if there is nothing in the cells, and you can have the macro run automatically when the workbook is opened ([FONT=&quot]Sub Autpen() )[/FONT].

I hope that helps,
Regards
Alan

 

[Joe4]

Macros can be written to be run manually or automatically. There is a lot of flexibility there.
They can be set to run automatically upon a variety of events, like opening a workbook, closing it, switching sheet, selecting a cell, updating cells, etc.
Chip Pearson did a good write-up on these "event" procedures. Here is a link: Events In Excel VBA