Have a macro that creates a new file. In the new file is a tab called
"Review" which has a macro attached to it. The macro is attempting to copy
data from the "review" tab to the "Output" tab in the same workbook.

I am running into problems once I select the "output" tab in that VB will
not select any cells on the output tab. Instead it provides an
error(Application defined or object defined error).

Is there a way to overcome this and allow a sheet macro to perform steps on
another sheet?

Here is an abbreviated version of the macro

Sub test()
range("A2:a35).select
selection.copy
Sheets("Output").Select
Range("a2").Select 'The error occurs here
Activesheet.paste
End Sub


--
Joe D