Sharid
Well-known Member
- Joined
- Apr 22, 2007
- Messages
- 1,064
- Office Version
- 2016
- Platform
- Windows
Hi
I have been stuck on this one for sometime now and need so help, please. I need a code that will create variations of urls.
In Sheet 1 I will have a list of urls, column A row 2 down. Some urls may NOT end with a forward slash, the urls will also end with different prefix .com .co.uk .org and so on.
In Sheet2 I will have the variations I need it to create of the url.
When the command button is clicked I need the following to be created, in Sheet1 Column A Row 2 Down. The red colour is only for your reference its is not necessary.
I am not sure if it is possible to delete everything after the prefix e.g. .com .co.uk and so on in the url BEFORE it created the variation of the url.
I can not seem to work it out. As always thanks in advance.
I have been stuck on this one for sometime now and need so help, please. I need a code that will create variations of urls.
In Sheet 1 I will have a list of urls, column A row 2 down. Some urls may NOT end with a forward slash, the urls will also end with different prefix .com .co.uk .org and so on.
In Sheet2 I will have the variations I need it to create of the url.
When the command button is clicked I need the following to be created, in Sheet1 Column A Row 2 Down. The red colour is only for your reference its is not necessary.
I am not sure if it is possible to delete everything after the prefix e.g. .com .co.uk and so on in the url BEFORE it created the variation of the url.
I can not seem to work it out. As always thanks in advance.
Last edited: