select a range

i'm extremely new to this VBA programming. in fact so new i'm only just working myself through my first book. "VBA for dummies"!!

anyway i have a few specific reasons why i want to be able to adapt excel to start automating many of the repetative functions i continuously do on data.

i want to add a column to every spread sheet (with my data on) copy another column then format it all the same.

i can actually do this with what i have learnt so far. my problem is this:

every workbook that comes to me has a different number of rows. therefore when i write the code i need to select a different number of rows as the range to format each time. could someone please point me in the right direction to just select a range that extends to just the number of rows with data in.

does this make any sense to anyone ?!

thank you for you help in advance


mark

Cross posted at http://www.vbaexpress.com/forum/show...d=1#post123056. I have given you a bit of a start at the otehr thread. Please don't cross post, it means people can end up wasting time on problems that have already been solved, and is likely to result in your thread being closed.