What I am doing is finding two cells that I would use to select a block of cells. The rows are constants and do not change however the starting column C1 and ending column represent a starting date and a finishing date. The columns in the spreadsheet represents dates and I want to copy the columns for a certain date range (Billing Month) and then paste them into a report worksheet which gets printed and is used to create an invoice. Since I determine the block of cells based on counting the number of days in the billing period, I have to use the cell method for determining range because it allows cells to be identified by column number and row number. If this is not the case, how can I use column numbers and row numbers to specify a block of cells.

Dan