Dave,
Try using the Offset function, and reference your cells using that.

For additional help reference http://www.contextures.com/Dynamic for dynamic
range references

HTH


"socaldave469" wrote:

While working in two workbooks, I would like to create a formula in the first
workbook that looks at a particular column, (example column AE), and not its
contents. As it is now, I created a formula to look into cell AE1, but when
deleting column AB, column AE becomes column AD, which is not what I want.

Help please.

Thanks,

Dave