How would I reference that in VBA? I tried using the macro recorder,
but can't decipher what the verbage is for adding to and subtracting.

I have tried:
ActiveWorkbook.Names("Bob").Value = _
Right(ActiveWorkbook.Names("Bob").Value,
Len(ActiveWorkbook.Names("Bob").Value)-1) + 1

But that errors out....

I can't seem to find this in the help file either... any suggestions?

Random.


On Thu, 14 Aug 2003 20:11:31 -0500, "Chip Pearson"
wrote:

Random,

You might consider storing the value in a defined name.