reference cells when looping
Dave Peterson wrote in
:
It depends on what you mean.
If you want to extract the characters A-Z and a-z and eliminate
everything else, you could loop through the text and look for those
characters.
If you want to keep the first x number of characters (or the last x
number of characters) or even the characters after some indicator
(like everything after the initial hyphen in: xxx-ab23cd), the code
would be different.
And what reference do you mean? I'm guessing tcell, but not sure.
Isis wrote:
snipped
Dave,
Thanks for that !
If wanted to get the 'alpha' part of the reference and put it into a
variable, how would I do that ?
Thanks again thats a good problem solved.
Dave,
thanks for answering - yes I meant the current cell - the current address
that tcell is pointing to - so if it is currently G17 - just the 'G' bit
- but maybe things like offset etc are a better way to go.
Thanks again
|