I am trying to understand the activeX controls a little better. I have been able to figure a few out, but the paste special transpose is causing me some problems. I understand the VB line

object.PasteSpecial(Paste, Operation, SkipBlanks, Transpose)

I can get these two lines to work, which paste values. Unfortunately, my limited knowledge of the activeX controls is causing me to hit a roadblock. I have about 70 columns that need to be converted into rows and there are about 250 lines in each row. I can go through the sheet one cell at a time, but it would take a long time and the paste special transpose would work faster.

oXL.Selection.PasteSpecial(-4163)
oXL.ActiveCell.PasteSpecial(-4163)

Can anyone help me in getting the transpose to work?

I have looked in the visual basic object browser and can find the paste special syntax for basic. Is there anywhere (books, web sites) that I can find help in converting that to VFP so I will not have to ask what is probably a dumb question.

Thanks
Todd