insert rows w/o updating cell references
Posted by stacy on January 04, 2002 7:58 AM
This may not be a VB question...but any help is appreciated. I have 2 sheets...sheet 1 refers to sheet 2. All of the cell references in sheet one have $ signs to keep them static. But....when I paste my "raw data" to sheet 2, I have to insert a couple blank lines in order for it to match Sheet 1's references. When I insert the rows, sheet 1 changes the references. I do not do want it to change references. I want them to stay the same all the time. Thanks for the help!!