+ Reply to Thread
Results 1 to 8 of 8

macro not giving desired output

  1. #1
    Registered User
    Join Date
    03-19-2009
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    9

    macro not giving desired output

    Hello All,

    I have attached an excel spreadsheet wherein it has three worksheet with same data structure. I want macro written and working for all three worksheets as currently it is working for one sheet at aa time and has to be invoked again and again
    ------code starts from here----------
    Please Login or Register  to view this content.
    --------code ends here-----

    Any help provided would be appreciated.

    Regards
    Last edited by royUK; 03-23-2009 at 03:15 AM.

  2. #2
    Registered User
    Join Date
    03-19-2009
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: macro not giving desired output

    oops.....forgot to upload the attachment !
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983

    Re: macro not giving desired output

    You also forgot to follow the forum rules & wrap your VBA code (Rule 3)

    Please take a couple of minutes and read ALL theForum Rules then wrap your VBA code (Rule 3)


    The easiest way to use code tags is to click on the # icon in the text formatting window

    This will add
    [ Code] [\ Code]
    to your message window with the cursor between the ][ brackets - this is were your VBA code goes.
    You will not see your code displayed correctly until you preview or post your message

    Note:- there is no space before the word Code like I have shown in the example above

    Please Login or Register  to view this content.
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

  4. #4
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    Re: macro not giving desired output

    Hi
    Add ws in these code lines as shown below

    Please Login or Register  to view this content.
    ravi

  5. #5
    Registered User
    Join Date
    03-19-2009
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: macro not giving desired output

    Hi,

    Pls find attached the non working code in the format specified.
    Any help from anybody??

    Ankur


    Please Login or Register  to view this content.

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: macro not giving desired output

    This is a continuation of this question. Read all the Forum Rules and you will see that you should not start another question on the same subject.

    There is no code in your workbook, so how can we check it?

    You didn't say anything about having hidden sheets either

    Please Login or Register  to view this content.
    Last edited by royUK; 03-23-2009 at 03:43 AM.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  7. #7
    Registered User
    Join Date
    03-19-2009
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: macro not giving desired output

    Hello Roy,

    I am extremely sorry for the inconvenience caused due to my ignorance.
    Well i have attached an excel spreadhsheet that consists of your code.
    The code is working fine but for one sheet only ,have to run it again for other sheets which defeats my purpose as i want to run the macro only once.

    Kindly share your thoughts on this !

    Ankur
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    03-19-2009
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: macro not giving desired output

    thanks a lot Ravi......changes reco by you did exactly what i wanted....

    Thanks once again

    Ankur

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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