Tezzies
10-23-2008, 03:50 AM
The range is stored in a cell on sheet 2----> $K$5:$P$137
The range refers to cells on sheet 1.
If certain conditions are met i wish to in increase 137 by 1 . What is the best best method.
1. Resize the range by setting it, then using "resize" Then rewriting its dimensions to sheet 2 cell
or
2. Or editing the cell with $K$5:$P$137 in it (I am reluctant to use this method because it would involve detecting the last $ and counting the number of characters afterwards eg 137 = 3 and 45 = 2.)
or
3. A better method you guys will tell me about:hi:
Many thanks
The range refers to cells on sheet 1.
If certain conditions are met i wish to in increase 137 by 1 . What is the best best method.
1. Resize the range by setting it, then using "resize" Then rewriting its dimensions to sheet 2 cell
or
2. Or editing the cell with $K$5:$P$137 in it (I am reluctant to use this method because it would involve detecting the last $ and counting the number of characters afterwards eg 137 = 3 and 45 = 2.)
or
3. A better method you guys will tell me about:hi:
Many thanks