Why not just put a code in a cell when there is no week 5, and check that in
the VBA?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"hbp78 " wrote in message
...
Hey Guys/Girls,

I'm trying to create a Macro that takes weekly data for a months time
frame and creates averages for trend tracking. The end result would be
a graph for a visual presentation. The macro is almost complete;
however, the macro I made has to adjust for future month "structures"
(i.e. 4 or 5 weeks in a month). The macro built was based on a 5 week
month, yet when I run the macro with a 4 weeks worth of data it get's
caught up on the 5th week because it's blank.

Is there a way to say if worksheet "x" is blank skip the following
steps in the macro. The work sheet with data has been included and the
run funtion is (Ctrl+ E).

'Link' (http://www.iamhetero.com/fun/Monthly Average.xls)

Also, is there a way when copying information after it's been
subtotalled to pasted it without the hidden information?

Thanks for all your help,

Kevin


---
Message posted from http://www.ExcelForum.com/