Why do you think you need to use the Indirect function to do this? Using
sample ranges and sheet names (because you didn't tell us what you actually
are working with), this single line of code...

Worksheets("Sheet1").Range("A1:F99").Copy Worksheets("Sheet2").Range("C3")

will copy A1:F99 on Sheet1 (with its formatting) to Sheet2 starting at cell
C3.

--
Rick (MVP - Excel)


"Ken G." wrote in message
...
I need to copy a range from one worksheet and paste the values into another
sheet within the same workbook, but I need to use the Excel "Indirect"
function to paste it into the correct position. How is this done with a
macro? (Excel 2002)