Using code with changing cell references

[Chard]

Hi folks

When I'm creating a worksheet the value I'm working with is in cell A1. However, at some point this may change to another cell, and then to another.

When I'm writing my code I don't want to have to keep changing the Range reference every time I move the required cell value about on the worksheet.

Is it possible to do something like TargetCell = Range ("A1") and then I can use TargetCell in my code whenever I'm using this cell.

Then if at some point I move cell A1 to cell B14 on my worksheet I only have to change this one line in my code rather than search for all references to Range ("A1")

Hope I've explained this OK.

Cheers

Chard

[mudraker]

If you mean the value of A1 then

Please Login or Register  to view this content.

will give you that.
The prefered code is

Please Login or Register  to view this content.

You then can use

Please Login or Register  to view this content.

[Ikaabod]

If I understand you correctly this should work

Please Login or Register  to view this content.

So will have to do a little changing around in your code initially, but from there on out will only have to change the "myTargetCell" value.