Thanks Guys

I just changed Calculate to ActiveSheet.Calculate and it gave me what I
wanted.

I almost had it in my previous tries but I placed it in the worksheet code
module instead of the standard code module. Doh!

"Bob Tarburton" wrote in message
...
I need a simple macro to recalculate the worksheet (not the entire
workbook) whenever any cell in the range B5:G5 is edited.

I'm assuming it's a simple combination of Worksheet_Change and
ActiveSheet.Calculate

I've looked at Chip Pearson's event macros page, but can't seem to get it
right.

Thanks in advance for you help
Bob