Modify change event to absolute cell reference?

**Marvelous** · 11-10-2013, 01:25 PM

I need to change the following code so that when a user inserts a row above or below Cell D36, the change event (I think that's what this code/operation is called) still operates on the same cell. In the spreadsheet I would just add $ signs for absolute reference but I am not sure how to do this in VBA.

Please Login or Register  to view this content.

Your help is greatly appreciated!
Marvin

**mrice** · 11-10-2013, 01:55 PM

Suggest that you give the range D36 a name and then refer to this in your code. If the cell moves, the name will stay with the cell.

**Marvelous** · 11-10-2013, 02:21 PM

Mrice,

Thanks for your help. How do I do this? I'm a real newbie at Vba. Also, just in case it changes anything, I have several cells in a row that have this change event that I need to make absolute reference. The pattern goes like this:

Please Login or Register  to view this content.

Thanks again!

**Marvelous** · 11-10-2013, 07:03 PM

Mrice,

After a little experimentation, I figured out that I could name the cell in the spreadsheet and use that reference in Vba. You are the best!

Take care