Multiple Active Cells?

Can you have multiple active cells? I know this sounds goofy, but I have a few worksheets that refer to the active cell in worksheet 2 and I want worksheet 1 and 3 to refer to both refer to the active cell. If I have 2 active cells I can have 1 referenced to each worksheet.

The simple answer is you can only have 1 active cell at a time. In order to change the "active cell" on different sheets, you must first activate that sheet. Then the active cell will change to the active cell on the activated sheet.

HTH

Jason