linked cell
 

Hi.

Ive got a small question
Is there a possibility to link the VBA code to the cells? So when you are
referring to cell A1 and you insert a row the VBA script automatically
changes the value to A2.

Best regards,

Chris

linked cell
 

Click on the cell A1 then Insert(menu) Name Define ... name it "mycell"
Try inserting rows and columns the code below should refer to the same cell
because named ranges keep there relative reference when cells, columns or
rows are deleted or inserted.

Range("mycell") = Range("mycell") + 1

--
Regards,
Rocky McKinley


"chris" wrote in message
...
Hi.

I've got a small question
Is there a possibility to link the VBA code to the cells? So when you are
referring to cell A1 and you insert a row the VBA script automatically
changes the value to A2.

Best regards,

Chris

linked cell
 

use named ranges.
So when you insert a row, the named range also shifts and your VBA code is
not affected.

Mangesh



"chris" wrote in message
...
Hi.

I've got a small question
Is there a possibility to link the VBA code to the cells? So when you are
referring to cell A1 and you insert a row the VBA script automatically
changes the value to A2.

Best regards,

Chris