Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Varibles Used In All Modules

  1. #1
    Join Date
    28th February 2008
    Posts
    9

    Varibles Used In All Modules

    HI,

    I have a variable which is used in 17 modules. All the modules are huge. Is there a short and easy way to find out where and how many times is the variable used in my modules.

    I appreciate your help....

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    23rd September 2003
    Location
    York
    Posts
    880

    Re: Varibles Used In All Modules

    Hi,

    You could try printing the project to a file and use Word to find and count instances of a word.

    Not a vb solution but it may get you your answer.

    John

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    28th February 2008
    Posts
    9

    Re: Varibles Used In All Modules

    John,

    I have 17 modules. The modules are huge. Is there a short-cut to right click the variable and find out the no. of times it is used in all the modules....

    Plus, do you have a code where I can Print all the modules one by one to one text file and do the search and count....

    I apprecaite it...

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Varibles Used In All Modules

    You could use Find/Replace which would tell you number of occurances. It can also be restricted to module or project level searching.

    Cheers
    Andy


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Create An If Function With Multiple Varibles And Outcomes
    By corndawg12 in forum Excel and/or Word Help
    Replies: 4
    Last Post: October 20th, 2007, 07:24
  2. Replies: 2
    Last Post: September 21st, 2005, 06:25
  3. Global varibles and their values
    By Lalle in forum EXCEL HELP
    Replies: 3
    Last Post: June 16th, 2005, 02:09

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
  •  
porno