• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. P

    Shifting values to adjacent cells when F9 key is pressed

    Hi Guys, Thanks for your help. I have worked out a way of achieving what I wanted using a macro assigned to a button. If say A1 has my formula in it. I cut and "pasted special" (values only) A1 - A30 TO A2 - A31 and then recalculated A1 with F9 button. Every time the button is pushed, the...
  2. P

    Shifting values to adjacent cells when F9 key is pressed

    Hello Anupam, I am a bit of a VB novice. I managed to open a new module, paste the code into it and saved it. I couldn't find where to open a "workbook close event", do you have any suggestions where I should look? I am running excel 2003. Thanks for the help. PeterH.
  3. P

    Shifting values to adjacent cells when F9 key is pressed

    Hello Luke M, If you mean manually add the results to a table, well yes I could do that but I do enjoy manipulating excel to do things automatically. It's half the fun for me. Thanks for the suggestion. Peter H
  4. P

    Shifting values to adjacent cells when F9 key is pressed

    Does anyone know a way of moving a cell value to the adjacent cell when F9 is pressed to recalculate? For example if a number/value appears in cell A1 due to pressing F9 to recalculate the spreadsheet, then the next time the F9 key is pressed the value in A1 moves to the right (cell B1) and a...
Back
Top