Transfer Macro in Excel

  • Thread starter Thread starter sryan
  • Start date Start date
S

sryan

I am trying to transfer informtion in one sheet to another sheet in the
same workbook. I have a macro to process this information from the
first sheet to the second. I keep getting an error in this Process
macro at the line.
Application.Goto REFERENCE:=Range("END")

The first sheet is called ProblemSheet and the second sheet is called
Processed. The line above is taken from the process macro on the
ProblemSheet page. Do I have to name a certain cell as "END" on either
sheet? Any help with this would be really appreciated.
 
Do I have to name a certain cell as "END" on either sheet?

In order for your code to work there must be a cell or range of cells named
"end" on some worksheet in the active workbook. Use Insert, Name, Define
(or Ctrl-F3) to create a named range.
 
Back
Top