VBA Generate sheets with unique values

[QUOTE=mancubus;] google says The United Kingdom of Great Britain and Northern Ireland is 48 chars long... :D

I've never been one for formal titles, so I just call them "Great Britain" and "Northern Ireland", as I suspect most people would do.

Quote:

---

so prepare for war today.

---

Feathers at 15 paces, at dawn tomorrow.
PS: bring plenty of beer it could be a long long day

Quote:

---

Originally Posted by mancubus

google says The United Kingdom of Great Britain and Northern Ireland is 48 chars long...

---

I don't normally refer to countries with their formal regalia, just "Great Britain" & 'Northern Ireland". As I suspect most people would do also.

Quote:

---

so prepare for war today.

---

Quote:

---

:)

---

Righto, Crow feathers at 15 paces, at dawn tomorrow.

PS: Bring plenty of beer, it could be a long day.

Well, countries in our company are seperated, I hope it won't change :D ... Btw why the code can't take value longer than 31 characters?

The code can handle, I think, 255 characters. The Sheet Tab names can only take 31.

That is why in my example the sheets are named "Left(strCountryName, 31)".