Hello,
what i m trying to achieve here is - the activeworkbook, cell A2 should have a output only of 3 characters irrespective of the input file cell value.
Please Login or Register to view this content.
Hello,
what i m trying to achieve here is - the activeworkbook, cell A2 should have a output only of 3 characters irrespective of the input file cell value.
Please Login or Register to view this content.
this is completely untested but try
.TextLength = 3
I don't think this will work because I'm not sure .TextLength is an object
Last edited by judgeh59; 06-19-2015 at 10:56 AM.
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Would it work to shorten the value that is posted to the range
Please Login or Register to view this content.
Thanks stnkynts. It worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks