+ Reply to Thread
Results 1 to 2 of 2

changing one part of an url

  1. #1
    Registered User
    Join Date
    09-29-2016
    Location
    Spain
    MS-Off Ver
    2007
    Posts
    1

    Question changing one part of an url

    hello, sorry to disturb you... I was actually quit good in ICT in college but I just can't remember anything. =(

    Can somebody help me...
    I need that a part of an url changes.... so for example i have the url : http://www.mywebsite.com/wp-content/uploads/2015/06/01.jpg

    I need that the "01" changes in every row. so the next one would be
    http://www.mywebsite/wp-content/uploads/2015/06/02.jpg
    http://www.mywebsite/wp-content/uploads/2015/06/03.jpg
    http://www.mywebsite/wp-content/uploads/2015/06/04.jpg
    and so on....

    until for example 56...

    Would be very nice if somebody could help me =)
    Thank you

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,944

    Re: changing one part of an url

    Hi, welcome to the forum

    Try this...
    ="http://www.mywebsite.com/wp-content/uploads/2015/06/"&TEXT(ROW(A1),"0?")&".jpg"
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Changing a part of vba code
    By Milade8080 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2014, 08:11 AM
  2. Changing a part of a formula using VBA coding
    By nav505 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2013, 04:12 PM
  3. Fill down changing part, but not all of the formula
    By tallboy755 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-07-2013, 04:52 PM
  4. changing part numbers
    By DETRUCK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 01:49 PM
  5. Changing Part of Hyperlink
    By CaptCaveman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2012, 10:16 AM
  6. Changing Part of a Formula
    By Barrera006 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2011, 09:16 AM
  7. Changing 10K part numbers
    By fulford in forum Excel General
    Replies: 12
    Last Post: 02-24-2011, 12:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1