+ Reply to Thread
Results 1 to 2 of 2

parse public variables

  1. #1
    Forum Contributor
    Join Date
    02-05-2015
    Location
    czech
    MS-Off Ver
    2010
    Posts
    172

    parse public variables

    I have following code in which I state public variables and then I apply function on these variables. The function searches sheet for string and returns the column number where the string is found.

    Please Login or Register  to view this content.
    Is it possible to apply function searchC on all public variables or some group of public variables at once without so many lines? The names of public variables can't be generated by loop. The names are just random names without common root. Names ab1...ab100 are in code just for illustration.

    Also I don't know if it is correct way of doing the thing I want to do. The purpose of this code is mark data in columns with string which is easily remembered. Then in my code I can reference to this column by short string without the need to remember or check in which column number the data are. Maybe there is a better way for doing this.
    Last edited by jakopak; 10-28-2015 at 03:22 AM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,703

    Re: parse public variables

    How about not using public variables, but public names (named ranges)? then you could do tricks like assigning values to any name (there are limits for manes so abc1 would be invalid but _abc1 would be fine.
    Best Regards,

    Kaper

+ 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] Public Variables
    By iamGreenhorn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-21-2014, 12:38 PM
  2. Public Variables
    By carsto in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2008, 03:56 PM
  3. Public variables
    By Tomski in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2006, 10:20 AM
  4. [SOLVED] Public Variables
    By daniroy@gmail.com in forum Excel General
    Replies: 6
    Last Post: 09-12-2005, 12:05 PM
  5. Public Variables
    By johnhildreth@charter.net in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-01-2005, 12:05 PM
  6. [SOLVED] Public Variables
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-21-2005, 07:06 AM
  7. Public variables
    By jcp29 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2005, 07:10 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