Quinn
03-22-2006, 02:26 PM
I'm using VBE to take a row from Excel to transpose. Some of the cells,though, contain formulas (e.g. ="Patient Disposition") instead of values ( e.g. Patient Dispositon). So, I get the ERROR 13 , when trying to do something like:
Array2 = Array(Range("A1:V1").Offset(X, 0).Value)
'transpose rows to become 2nd column
Range("B15:B36").Value = Application.WorksheetFunction.Transpose(Array2)
any ideas?
Thanks:beerchug: "Life's too short for American Beer"
Array2 = Array(Range("A1:V1").Offset(X, 0).Value)
'transpose rows to become 2nd column
Range("B15:B36").Value = Application.WorksheetFunction.Transpose(Array2)
any ideas?
Thanks:beerchug: "Life's too short for American Beer"