Remove iNdex chars From Left
Hello Forum
I made in a macros this formula :LEFT(RC[-1],(LEN(RC[-1])-2))
is removing from left side an index , like in this example '
9117 - 570-65CE49D-B4-7 to obtain 9117 - 570-65CE49D-B4
so here is my code,
is with an userform, but it gaves me an error, that my procedure is invalid
Please Login or Register to view this content.
Last edited by teodormircea; 05-21-2009 at 08:19 AM.
You had better wrap your code in code tags before it gets spotted.
Edit your post, click the 'Go Advanced' button, then select your code, and then click the '#' button above the edit area.
It makes it much easier for others to read your code then
Thanks, didn't to make truble
I think i found the problem, it doesn't work if a have blank cells.
How to avoid this problem
I have not used userforms, but if the blank cell is causing you problems then the alteration below should overcome it for you:
becomesPlease Login or Register to view this content.
Please Login or Register to view this content.
If you find the response helpful please click the scales in the blue bar above and rate it
If you don't like the response, don't bother with the scales, they are not for you
here a solution, with a condition for blanks
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks