jungix
08-28-2006, 10:30 AM
Want a formula refers to a cell and the cell is moved in VBA the content of the formula moves with it (except maybe if it is referred to with $).
However, in VBA if I insert a column in my Excel sheet, the references in my VBA code won't change.
I know I could define my ranges in VBA with find and offsets but that would be very heavy.
Is there a simple way for code to be updated as we move/delete/insert cells/rows/columns?
However, in VBA if I insert a column in my Excel sheet, the references in my VBA code won't change.
I know I could define my ranges in VBA with find and offsets but that would be very heavy.
Is there a simple way for code to be updated as we move/delete/insert cells/rows/columns?