making lots of reference changes

[Warhammer]

here is the string;
='\\SERVER1\Production\Shared\KPO\Quality\teardowns\Mattress\[9A Mattress Teardown.xlsx]1'!$P$24

we need to be able to get the tab reference (the 1) to be able to be changed across multiple cells (30-50). ideally it would be able to increase numerically like a relative refrence.


help?

 

[ParamRay]

.
.

Supposing you declared variable i as an integer. Then you could adapt something like the following line to suit:

Range("A1").Formula = "='\\SERVER1\Production\Shared\KPO" & _
"\Quality\teardowns\Mattress\[9A Mattress Teardown.xlsx]" & i & "'!$P$24"