The cell in another worksheet that contains data to which the link refers is called a precedent cell. Dependent cells automatically change if the precedent cells change.

For instance, if a cell in one worksheet has a sales number, you can display that value in another worksheet by adding a reference to that cell.

I need to be able to get a date value stored in an Excel spreadsheet (say, C Temp\file.xls) in cell B28, and put that value into a variable to then use it in a VBA module in MS Access. <BR><BR>I ...

Learn how to identify formula cells the easy way using VBA, and then combine VBA and conditional formatting for more permanent identification.

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.