Sheet Macro Help Needed

  • Thread starter Thread starter Joe D
  • Start date Start date
J

Joe D

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
 
You dont need to select the sheet to copy. Try the below which copy the range
from active sheet to sheet output

Sub Macro()
Range("A2:a35").Copy Sheets("Output").Range("a2")
End Sub

If this post helps click Yes
 
Another way.........

Range("sheet2!a2").Formula = "=sheet1!a2"
Range("sheet2!a2").AutoFill Destination:=Range("sheet2!a2:a35")

Vaya con Dios,
Chuck, CABGx3
 
How did you attach the macro to a sheet?

Your code runs fine if macro is stored in a general module and run when
Review sheet is active.

See other posts about "selecting"


Gord Dibben MS Excel MVP
 
Back
Top