Modifying existing code

**rhouston08** · 03-13-2015, 02:25 PM

I found this code online, that copies "Sheet2" and renames the new worksheet based on a range listed on "Sheet1" (starting in A2). If "Sheet1" was renamed to "Listing", how do I modify this code in order to make sure that the code will always pull from "Listing" and not "Sheet1"?

Please Login or Register  to view this content.

**Kaper** · 03-13-2015, 02:48 PM

The macro just pulls data from column A in the sheet which is active when it is called.
The only sheet which is explicite named here is Sheet2, which is used as a template for newly created sheets.
if you want to make sure it is always pulling data from Listing sheet change in first few lines:

Please Login or Register  to view this content.

**sjd371** · 03-13-2015, 02:50 PM

just ad Sheets("sheet name").select to the code. then no matter what sheet you are on the code will always go to that sheet first.

Please Login or Register  to view this content.

**rhouston08** · 03-13-2015, 03:36 PM

Thank you Kaper and sjd371, both ways worked for me and i'm good to go now.

**Kaper** · 03-13-2015, 06:03 PM

you are welcome. would be nice if you mark thread as solved.

Modifying existing code

LinkBack

Thread Tools

Rate This Thread

Display

Modifying existing code

Re: Modifying existing code

Re: Modifying existing code

Re: Modifying existing code

Re: Modifying existing code

Thread Information

Users Browsing this Thread

Similar Threads

Modifying the code in an existing workbook to add extra Category fields

[SOLVED] Add two more columns, modifying an existing VBA code help.

Modifying Existing Code to Check if the entry exists

Modifying existing VBA code to find different file name

Help modifying existing VBA code

Bookmarks

Bookmarks

Posting Permissions