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