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

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.