+ Reply to Thread
Results 1 to 4 of 4

Ms Excel 2003 running a script

  1. #1
    Registered User
    Join Date
    09-23-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    28

    Ms Excel 2003 running a script

    Hello everyone ,
    is that possible to search for a Keyword which is present multiple times in the spreadsheet and then I need the cell number for each of its occurrence which i need in order to calculate in a script. Please let me know if its possible , I m new to excel so really need ur help
    Last edited by satpalbhullar87; 09-23-2013 at 04:37 PM. Reason: typos

  2. #2
    Forum Contributor
    Join Date
    09-11-2013
    Location
    Huntsville, AL
    MS-Off Ver
    Excel 2007
    Posts
    180

    Re: Ms Excel 2003 runnign a script

    Hi, can you give us an example?

  3. #3
    Registered User
    Join Date
    09-23-2013
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: Ms Excel 2003 running a script

    Hey dere,
    sureBook1.xls
    so here , if u see i want to search for "Ryan" and then i need to get the cell location for all the occurence of it, once i get that i want to calculate the effort
    Last edited by satpalbhullar87; 09-23-2013 at 05:02 PM.

  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: Ms Excel 2003 running a script

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    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]

+ 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. Excel 2003: VBA script to colour cell that contains part of text
    By garoe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2013, 06:22 AM
  2. script written in excel 2003 not working for excel 2007 and above
    By justinng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2011, 06:46 AM
  3. Excel 2003 converting with 2007 but have script
    By feejo in forum Excel General
    Replies: 1
    Last Post: 12-29-2007, 11:56 AM
  4. File size after runnign macro
    By r_dearn in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-25-2006, 04:44 AM
  5. [SOLVED] How to create a script to trust an assembly - Excel 2003 - Office System Project with C#
    By John Yung in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-06-2005, 10:05 AM

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