is it possible to create a macro that can take into account the number of
columns containing data? in a workbook i have a tab for each month of the
year for 2001-2008, and because each month has varying numbers of days in it,
the number of iterations i need to do differs, and the number of columns for
iterations changes back and forth from 6 to 7. im just looking for a
time-saving method instead of manually including or removing the number of
columns to consider.

thanks in advance.