Results 1 to 5 of 5

Set the range

Threaded View

jasond1992 Set the range 11-24-2015, 08:56 PM
Richard Buttrey Re: Set the range 11-24-2015, 09:07 PM
Trebor76 Re: Set the range 11-24-2015, 09:15 PM
jasond1992 Re: Set the range 11-24-2015, 09:41 PM
Trebor76 Re: Set the range 11-24-2015, 11:24 PM
  1. #1
    Forum Contributor
    Join Date
    08-20-2015
    Location
    philippines
    MS-Off Ver
    2013
    Posts
    260

    Set the range

    Anybody here can help me to set the range of this program ? This Program is to link the folder name. if you run will start the Sub Folder in A2.
    I want the range start in A5 what do i need to edit ? and if i use a table in cell they will put inside the table in B5. This code when i run they put the link into the last cell of the table. Here's my file and Code. I Wish you can help me. Thanks. GOdbless...

    Credit to sir. AlphaFrog to this program.

    Sub Hyperlink_Subfolders()
        
        Dim fldr As Object, sPath As String
        
        sPath = "C:\Users\User1\Desktop\Commercial PDF_Files\P.O\STANDARD\"
        
        Application.ScreenUpdating = False
        For Each fldr In CreateObject("Scripting.FileSystemObject").GetFolder(sPath).SubFolders
            ActiveSheet.Hyperlinks.Add Anchor:=Range("A" & Rows.Count).End(xlUp).Offset(1), _
                                               Address:=fldr.Path, TextToDisplay:=fldr.Name
        Next
        Application.ScreenUpdating = True
        
    End Sub
    Attached Files Attached Files
    Last edited by jasond1992; 11-24-2015 at 09:42 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-24-2015, 03:00 AM
  2. [SOLVED] Help! - Copy Range (Sheet1,A10:F50), Paste Range (Sheet 2,A1:F41), Offset Range & Repeat
    By cjtimmer in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-30-2015, 06:27 PM
  3. Replies: 4
    Last Post: 08-04-2014, 04:48 AM
  4. [SOLVED] Count number of occurances below a range, within a range, and below a range
    By maacmaac in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2013, 11:36 PM
  5. send to range, popup box to input what the range should be each time/select range
    By lax2734 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2012, 01:37 AM
  6. Change range of cells within VBA macro and copy and paste to fixed cell range
    By Mannyny in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-20-2012, 11:51 AM
  7. Range Question / error 1004: method Range of object Worksheet has failed
    By Paul in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2005, 10:06 AM

Tags for this Thread

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