Thanks for the great tutorial. How would I change the code to allow every input into the column to have the hyphens removed? If I change the Range from ("C3") to Range("C3:C10") for example, I get a mismatch error.
WOOOOOOOOOOOOOOOW this is super easy :) Found a couple of methodes that take about 10 rows or more, this will make my code look much more elegant ;) best regards
How do i do this in a range of cell? like remove - from C2:C45 Thanks,
Thanks for the great tutorial. How would I change the code to allow every input into the column to have the hyphens removed? If I change the Range from ("C3") to Range("C3:C10") for example, I get a mismatch error.
Unfortunately, this only work for one cell at a time. If you change the range to multiple cells you'll get an error.
WOOOOOOOOOOOOOOOW this is super easy :)
Found a couple of methodes that take about 10 rows or more, this will make my code look much more elegant ;)
best regards
Great, thanks!!
Nothing comes easy with Microsoft does it