Copy/Pasting and then Formatting a Table

Hello,

I am working on a program that does a whole bunch of analysis over 16 sheets of 640x512 pixel values and then copies the data of interest in a new sheet and formats it as a table to be imported into a word template so that it will be easy for the user to get the report of the information that is needed without having to do the analysis and sort through the excel document. I have the program able to load and analyse the data, save the document and do everything I need. I am having trouble importing into word but that will be on a different thread. The problem I am posting to help solve is that I am looking for a cleaner way to structure the following code:

Please Login or Register  to view this content.

The problem I am running into is that it is giving me an error on the first "" Range("B2").Value ="Std. Dev.'!D534" "".
The error is: "application-defined or object-defined Error."
I wasn't getting this error when I ran it 3 days ago but not I seem to be having troubles with it.

Is there a cleaner way to do this? I really hate the 'Copy and Paste' Method but I couldn't figure out of to get the auto fill to cycle through the referenced cells that are in the Formula too.

Thank you Bernie. This code looks way cleaner and is executed much faster. The issue I am having now however is ( And I should have said this in my original post) The data I am copying from the Std. Dev. sheet is horizontal and I need it to be pasted into a vertical orientation from left to right to top to bottom respectively. Is there a transpose function?

Thank You, That edit worked perfectly! Got my project back on track!