+ Reply to Thread
Results 1 to 4 of 4

Do we have a best practices or sample code section?

  1. #1
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Do we have a best practices or sample code section?

    As I read the forums, I see that the question, "How do I copy a sheet from one workbook to another?" is asked almost daily.

    I've come up with a generic workbook that could be used in two ways:

    1. You could make a copy of it, and build your workbook around it by adding sheets and formulas, etc. and hide the Control Panel sheet when you are done with it.

    2. You could copy the code into an existing workbook and in the initialize variables section, "hard code" the items that are currently looked up from static named ranges on the Control Panel Sheet.

    Is there some place where it would be appropriate to post this workbook (along with the yet-to-be-written instructions).

    I'd post the workbook here for reference, but there's no advanced button.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Do we have a best practices or sample code section?

    How about the Tips and Tutorials forum?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Do we have a best practices or sample code section?

    D'oh! I don't scroll down this far in the forum that often. - Thanks

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Do we have a best practices or sample code section?

    Darn, I can't attach a file there either. I'll have to put it in the VBA section.

    P.S. I'm suffering from lack of attention. Of course I can attach a file there.
    Last edited by dflak; 10-26-2016 at 09:14 AM. Reason: Add PS

+ 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] Represent (define?) a section of code with a variable (shorten long code lines)?
    By Gene@action in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-01-2016, 03:59 PM
  2. [SOLVED] Excel Macro Visual Basic code not looking at all sheets with second section of code.
    By Heinrich Venter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-10-2014, 08:26 AM
  3. Moving section headings from below section to above section..
    By Fayebaline in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-24-2011, 06:58 AM
  4. Make code faster/better best practices
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 12-29-2008, 10:25 PM
  5. looking for: sample workbooks to illustrate best practices or useful techniques
    By lalbatros in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2007, 06:00 AM
  6. [SOLVED] do anybody have a sample code for executing excel macro from vb code?<eom>
    By B Deepak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-30-2005, 05:05 AM
  7. Need Sample VBA Code
    By Bill Sturdevant in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2005, 07:06 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