have a look in vba help index for convertformula

--
Don Guillett
SalesAid Software

"Jamie A Miller" (donotspam) wrote in message
...
I set up a very large workbook. I have linked the formulas of one sheet
to
another, however, I need the columns to be rows and the rows to be
columns.
I have linked the values, but I need to make all the cells in the sheet
absolute before I can transpose them. There are over 20,000 cells and I
really don't want to hit the F4 key 20,000 times in the sheet. A replace
would not work for this, as the data is too big. I have tried a copy and
then paste special- paste link, but it only makes the reference absolute
when
one cell is copied at a time. Any ideas on making many cell references
absolute at once?