Thanks Pete. So what your last comment is saying is that I can just say to start the substring at the 9th position and it will pick up everything from that point on or do I have to tell it how many characters to go from the starting point. The reason is I have control checkboxes, and I needed to take the numbers from the names of the checkboxes to do a loop that will only make a range of checkboxes visible. My range is from checkbox2-checkbox30. The main reason I wanted to understand what this does, is that I want to rename the cells that these checkboxes are in so that the cell w/ checkbox 2 will be renamed to "Box 2". Then write a loop that will check if checkbox2 value it true. If it is true, then I want to change the locked on "Box 2/cell" to true. Also, if there is text in "Box 2/cell", then I want to make checkbox2 visible to be false. This way they can either select the checkbox or type text in the cell, but not both. Any help would be great. Thanks. Matt