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
Bookmarks