Hi all,

I'm trying to write code that would pick up the existence of a year within a
selected cell and increment it by one, and I've been running into quite a few
snags.
For example, the goal is that the procedure should pick up the number 2007
in the following cells and turn it into 2008:
Revenue 2007 Plans
2007
Cost Center 20079 in Year 2007

I've managed to make it work for the first 2 examples, but I'm frankly out
of ideas for the instance where the cell contains a number that's similar to
2007. Any suggestions are greatly appreciated.

--------
Thanks,
Anony