Is there a way to use cell references in macros so that the cell references are automatically adjusted if row/columns are added/removed (the way that formulas in a worksheet automatically adjust)? As far as I can tell, I would either have to name every range that is used in the macro, or go into the VBA and manually adjust all affected cell references. Thanks.