Hi,

Can someone help me on a VBA problem I having. I have a workbook with quite number of worksheets and I'd like to perform calculations on some of my worksheets using cells from that are before and after the worksheet. This has proved surprisingly difficult to do. Does someone have a method for reading the names of previous and next worksheets and then putting cells into an equation?

For example I have worksheets in say a workbook colour : Red, Green, Blue, Orange , Brown.

For worksheet Green I want to automatically formulate an equation like Red!A1 + Blue!A1. For worksheet Blue an equation like Green!A1 +Orange!A1 and so on.


If anyone can help me out that would be great!


S_OB