+ Reply to Thread
Results 1 to 4 of 4

Need to use looping

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    152

    Need to use looping

    Hi,

    I have the following codes

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    using the same code for other professionals also ("Business", "IT manager", "Student" etc.,)

    Is there any way to pass the profession as arguments to avoid multiple lines of coding. I have around 25 professions list.

    Please help
    Last edited by gan_xl; 09-16-2013 at 10:44 AM.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Need to use looping

    Are there separate conditions for each profession?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor
    Join Date
    03-13-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    152

    Re: Need to use looping

    Hi Arlu,

    Just need to count the number of each profession in Column M and will have some calculation based on that.

    Thanks

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Need to use looping

    So why not use formula like countif for it? Why do you want to use a macro?

+ 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. Do Until Looping (not looping through all other columns)
    By orle8050 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2013, 10:37 AM
  2. Looping
    By Nordeen1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-15-2012, 12:31 PM
  3. Looping through row
    By dirtydan86 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2012, 10:53 AM
  4. Help:Looping
    By Buffyslay in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2006, 02:00 PM
  5. Looping
    By teresa in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2005, 09:05 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