Results 1 to 5 of 5

creating variable within Sub to run a Function

Threaded View

  1. 07-21-2016, 12:43 PM #2
    mikeTRON
    mikeTRON is offline
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: creating variable within Sub to run a Function

    Why not change your original macro to use an IFERROR vlookup formula?
    IFERROR(VLOOKUP(LookupCell,Range,Column#,false),VLOOKUP(LookupCell,NEWrange,Column#,false))
    All in I don't see why you cant solve this with formula logic instead of VBA logic.
    Last edited by mikeTRON; 07-21-2016 at 12:46 PM.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Creating categorical variable
    By CP3 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-19-2014, 03:00 AM
  2. [SOLVED] creating a variable range in VBA to be copied to variable sheets
    By adamNBU in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-29-2013, 06:20 PM
  3. Call a constant/variable by creating another variable
    By pienaaj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-12-2013, 10:36 AM
  4. vlookup variable filepath one file variable can this be done via a function?
    By pauldbaker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2013, 10:10 AM
  5. Creating a variable in excel
    By Alexander_V in forum Excel General
    Replies: 4
    Last Post: 10-25-2011, 11:18 AM
  6. Creating a variable word art
    By jwongsf in forum Excel General
    Replies: 7
    Last Post: 01-26-2009, 11:40 AM
  7. creating a filename variable
    By Beast in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2007, 06:11 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1