Macro to format a sheet with variable # of rows

[Alex881]

I'm new to Macros, but I'm trying to write one that does the same formatting (e.g., bolds columns, adds a total, adds a column, etc) regardless of the number of rows. The data I'm working with will have a different number of rows each time, but the columns remain the same. I was wondering how to go about writing one. I've used the record macro feature with relative references enabled, but I can only get decent results using data that has the exact same number of rows. If I change the data and the number of rows I'm working with, the macro doesn't work properly. Maybe there's a tutorial for this sort of thing? That would help me out a lot.

Thanks!

 

[Alex881]

Thanks so much, Dante.

That's working quite well, actually. Only a few small formatting things I'd change, if I need to.

It works with both the ones with a total and the ones without a total. Really fascinating stuff.

I may update this thread if I have any other small changes, but really - thanks so much for the help. I'm glad to have something working well for a formerly tedious task!

 

[DanteAmor]

Thanks so much, Dante.

That's working quite well, actually. Only a few small formatting things I'd change, if I need to.

It works with both the ones with a total and the ones without a total. Really fascinating stuff.

I may update this thread if I have any other small changes, but really - thanks so much for the help. I'm glad to have something working well for a formerly tedious task!

I'm glad to help you. I appreciate your kind comments.