+ Reply to Thread
Results 1 to 7 of 7

No correct output

  1. 02-27-2014, 12:13 PM #1
    mukeshbaviskar
    mukeshbaviskar is offline
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    No correct output

    Hi,
    I have sr. no. in column 'b' and I want to transfer it automatically in column 'ag'. I have inserted a code in sheet code but it's giving wrong output. It transfers the value from column 'c' but I want the value from column 'b' in column 'ag'.

    The code is:

    Please Login or Register  to view this content.
    Please suggest me a correction.

    Thanking you in anticipation.

    Sincerely,

    Mukesh
    Reply With QuoteRegister To Reply
  2. 02-27-2014, 12:16 PM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: No correct output

    You don't refer to column B anywhere in the code.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 02-27-2014, 01:15 PM #3
    mukeshbaviskar
    mukeshbaviskar is offline
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: No correct output

    Hi Norie,
    Sorry, now I have modify the code but getting syntax error. Please check it.

    Please Login or Register  to view this content.
    Thank you.

    Regards,

    Mukesh
    Reply With QuoteRegister To Reply
  4. 02-27-2014, 01:20 PM #4
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: No correct output

    I think you are over complicating things.

    If you want to transfer the value from column B to column AG all you should need is this.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 02-27-2014, 01:22 PM #5
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: No correct output

    Hi, Mukesh,

    how many more times will you come with the same basic codes and claim they don´t work for you alöthough you have been supplied with better ones?

    Please Login or Register  to view this content.
    still and always makes the check for
    Please Login or Register  to view this content.
    obsolete.

    Ciao,
    Holegr
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
  6. 02-27-2014, 11:15 PM #6
    mukeshbaviskar
    mukeshbaviskar is offline
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: No correct output

    Hi Holger,
    Sorry, I don't have a problem in this line. I have inserted it in the code and it's working fine. I have a problem in the code to transfer the value of column 'b' to column 'ag'.
    I don't want to trouble you friends. I have not completed any vba course. I'm learning it from you and forum friends time to time.So I'm facing the problems. I have learned a lot of things from you to speed up my work quickly using vba. So please don't mind.

    Sorry and thank you.

    Regards,

    Mukesh
    Reply With QuoteRegister To Reply
  7. 02-27-2014, 11:40 PM #7
    mukeshbaviskar
    mukeshbaviskar is offline
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: No correct output

    Hi Norie,
    Thank you. Now my problem is solved.

    Thank you Holger for guidance.


    Thank you.

    Regards,

    Mukesh
    Last edited by mukeshbaviskar; 02-28-2014 at 02:05 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Not getting correct output problem
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-19-2014, 08:44 AM
  2. [SOLVED] Error in sum formula not correct output
    By mukeshbaviskar in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2014, 11:40 AM
  3. [SOLVED] Not getting correct output value( Label & (i-6) & .Top)
    By annpricks in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2012, 03:44 AM
  4. Find and output correct path
    By 9437excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2011, 02:20 PM
  5. Month Function Not Displaying Correct Output?
    By NewExcelUser in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-29-2007, 03:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1