+ Reply to Thread
Results 1 to 2 of 2

How Many "Functions" Fit into a Macro?

  1. #1
    Registered User
    Join Date
    08-15-2015
    Location
    Orlando, FL
    MS-Off Ver
    ms 2016
    Posts
    5

    Question How Many "Functions" Fit into a Macro?

    I am pretty new to the VBA side of Excel, but understand how to record my own basic macro. I have a sheet in which I need to change the value of one column to something else completely. Right now, I am using a basic find and replace function (right word?) to do this. However, the project is hundreds of these functions. So my question is how many of these functions/lines can fit into a macro before it is no longer functioning? It seems that once I get passed a certain number it stops to function - but due to the high volume of entries the exact number is hard to track down. I am just trying to get a basic idea so that I can reset these macros and be sure they run correctly. I cannot seem to find an answer to this online.

    I am attaching a sheet with the picture of just a small bit of the macro to understand what is in it, plus the same code just copied into the word document. As I learn more, I'd like to obviously know if there is a way in which to do this without adding a bunch of macros to run everything. If someone can just point me in the direction to learn that information, I would be grateful.

    Thanks in advance!
    Jen
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    36,772

    Re: How Many "Functions" Fit into a Macro?

    If you have repetitive code, you would normally loop it.

    Make a list in a separate sheet of the text to be replaced and, in the next column, what to replace it with. Then loop through the list substituting each pair in the Find and Replace code.

+ 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] Help on "IF", "FIND", "SUBSTITUTE", & "LEFT/RIGHT" FUNCTIONS
    By pooja135 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-20-2018, 03:56 PM
  2. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  3. Help?? After I run a macro, cells with "macro-formulas/functions" show "#VALUE!"
    By de_keda in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2015, 11:08 AM
  4. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM
  5. Replies: 3
    Last Post: 08-28-2010, 09:31 AM
  6. Replies: 5
    Last Post: 06-26-2006, 09:23 PM
  7. Please add a "sheet" function like "row" and "column" functions
    By Spreadsheet Monkey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2005, 12:15 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