Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007
    Posts
    88

    Unanswered: vba copy excel cells horizontally from one workbook to another workbook vertically

    Hi gurus,

    I need to write a vba code to copy a range of cells in one row in an excel workbook horizontally and paste them (by value not link or formula) into a column vertically in another workbook and vise versa, copy vertically in one workbook and paste them horizontally in another workbook. Is that doable? Would you please help me with the function? Thank you so much!

    newguy

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    probably best to ask this in the Excel thread
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2007
    Posts
    88

    I need to write the vba code in Access

    Quote Originally Posted by healdem
    probably best to ask this in the Excel thread
    I know it's a excel question. However, I need to write the code in Access. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •