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.

Please Login or Register  to view this content.

Hi,

This is one of the reasons that I prefer not to use tables when this sort of functionality is needed. Performing an End Up when you start on the last row will always find the last row of the table whether there's data in the table or not. If you convert the table to a normal range then you'll be OK.

Otherwise you could do an End Up, End Up twice. i.e.

Please Login or Register  to view this content.

Hi jasond1992,

Here's one way to do it:

Please Login or Register  to view this content.

Regards,

Robert

That's what i want sir Trebor. Thanks you so much. Godbless...

You're welcome. Thanks for marking the thread as solved and for the rep

Robert