+ Reply to Thread
Results 1 to 16 of 16

Transfer value to other cell without the furmula

  1. #1
    Forum Contributor
    Join Date
    02-07-2011
    Location
    Bhutan
    MS-Off Ver
    Excel 2007
    Posts
    244

    Transfer value to other cell without the furmula

    Hi ,
    I am looking for a code that will transfer the value of cells a1,b1,c1 to a7,b7,c7 automatically.

    Please Login or Register  to view this content.
    but something is terribly wrong. can something please help me .
    thanks in advance.

  2. #2
    Registered User
    Join Date
    06-29-2011
    Location
    MUMBAI
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    85

    Re: Transfer value to other cell without the furmula

    u have written it the otherway round.Where u want should be in the bracket of range and the value u want should come after equal sign.
    regards

  3. #3
    Forum Contributor
    Join Date
    02-07-2011
    Location
    Bhutan
    MS-Off Ver
    Excel 2007
    Posts
    244

    Re: Transfer value to other cell without the furmula

    can you please rewrite the code for me.
    thanks in advance.

  4. #4
    Registered User
    Join Date
    06-29-2011
    Location
    MUMBAI
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    85

    Re: Transfer value to other cell without the furmula

    i have written it in the simplest of forms
    Please Login or Register  to view this content.
    regards

  5. #5
    Forum Contributor
    Join Date
    02-07-2011
    Location
    Bhutan
    MS-Off Ver
    Excel 2007
    Posts
    244

    Re: Transfer value to other cell without the furmula

    my excel stopped responding when i wrote this code.

    Please Login or Register  to view this content.
    What should I do,
    thanks in advance.

  6. #6
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Transfer value to other cell without the furmula

    Please Login or Register  to view this content.

    Unless you turn event handling off it will get stuck in an endless loop, as each cell update calls the change event, which updates more cells.

  7. #7
    Registered User
    Join Date
    06-29-2011
    Location
    MUMBAI
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    85

    Re: Transfer value to other cell without the furmula

    thanks for that @Andrew-R
    regards
    Last edited by vipul.halbe; 08-11-2011 at 04:03 AM.

  8. #8
    Forum Contributor
    Join Date
    02-07-2011
    Location
    Bhutan
    MS-Off Ver
    Excel 2007
    Posts
    244

    Re: Transfer value to other cell without the furmula

    Please Login or Register  to view this content.
    I rewrote as you said ...
    and it's working ...thanks a ton..
    Last edited by fatalcore; 08-11-2011 at 04:07 AM.

  9. #9
    Forum Contributor
    Join Date
    02-07-2011
    Location
    Bhutan
    MS-Off Ver
    Excel 2007
    Posts
    244

    Re: Transfer value to other cell without the furmula

    hi,
    i have modified the code as per my requirement.
    but i want the value to two cells to be in number..any help is much appreciated.
    Please Login or Register  to view this content.

  10. #10
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Transfer value to other cell without the furmula

    Please Login or Register  to view this content.

    Is that any closer? I've removed your error handling lines, as they weren't doing anything.

  11. #11
    Forum Contributor
    Join Date
    02-07-2011
    Location
    Bhutan
    MS-Off Ver
    Excel 2007
    Posts
    244

    Re: Transfer value to other cell without the furmula

    hi,
    it is giving me an error...type missmatch...

  12. #12
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Transfer value to other cell without the furmula

    OK, you're going to have to give us some clues - what is in the cells that you want to display in number format?

  13. #13
    Forum Contributor
    Join Date
    02-07-2011
    Location
    Bhutan
    MS-Off Ver
    Excel 2007
    Posts
    244

    Re: Transfer value to other cell without the furmula

    I have already mentioned that above,
    still here is the code. I have written that in the code section --> // i want the value in ......
    Please Login or Register  to view this content.
    thanks in advance.

  14. #14
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Transfer value to other cell without the furmula

    No, I get that you want the values in number format - what I want to know is what are they at the moment? In what way aren't they in number format? Are they strings, dates, something else?

  15. #15
    Forum Contributor
    Join Date
    02-07-2011
    Location
    Bhutan
    MS-Off Ver
    Excel 2007
    Posts
    244

    Re: Transfer value to other cell without the furmula

    ok, they are in present in general format.
    i have used this formula in Cells(14, 6)

    Please Login or Register  to view this content.

    and this formula in Cells(18, 6)
    Please Login or Register  to view this content.

  16. #16
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Transfer value to other cell without the furmula

    OK, if you want those cells to show percentages why not use the cell formatting options to make them percentages, rather than manually adding the % sign?

+ 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