View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
rwnelson rwnelson is offline
external usenet poster
 
Posts: 24
Default Overflow error - same code, different sheet

I figured it out. I put in the first line of the code as range("m2") =
sheets(1).range("M2") and this solved the formula problem.