Thanks guys. I tried all of your suggestions, and mudraker's was th
only one I was able to get to work without an error.

My knowledge of VB is basic, but I'm able to make sense of most of it
However, there are certain functions which confuse me, such as th
InStr with Left and Right.

I have one other question, which I tried figuring out myself, bu
didn't work.

If I want to change mudraker's code to increment the following...

Cells Z:2 through Z:9 have percentages within them, all the same, bein
22.58%, in the worksheet. I have to increment the formula: =14/62 by 1
but changing the 14 to a 15, so that the formula will become =15/62
changing the result to 24.19%, how do I do that now?

I tried playing around with the code, but messed up several ways, wit
some being that the result was in decimal form instead of percentage
and then got all 0's another way.


Thank you again in advance

--
Relyk
-----------------------------------------------------------------------
Relykk's Profile: http://www.excelforum.com/member.php...fo&userid=1575
View this thread: http://www.excelforum.com/showthread.php?threadid=27267