Copying the value of a cell from a previous sheet

[aaron.irvine]

Hey guys,

I've googled the heck out of this for the last hour, but I can't get it to work.

I've got a macro that imports a template sheet into a workbook with certain conditions. One of the conditions is to check the values in specific cells and return those values in the new sheet.

I've embedded the following code into the import sheet macro, but it crashes out of the routine at this point:

Please Login or Register  to view this content.

Any help would be greatly appreciated!

[aaron.irvine]

Just a little bump hoping some fresh eyes get to see this