This errors:
It seems to not like the Left
Cells(i, "W").Value = Left(Cells(i, "W") - 2).Value
This errors:
It seems to not like the Left
Cells(i, "W").Value = Left(Cells(i, "W") - 2).Value
Last edited by Aussiebear; 04-26-2023 at 06:39 PM. Reason: Adjusted the code tags
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!
Cells(i, "W").Value = Left(Cells(i, "W").Value,Len(Cells(i,"W").Value) - 2)
Last edited by Aussiebear; 04-26-2023 at 06:40 PM. Reason: Adjusted the code tags
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks!
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!