View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff S.[_2_] Jeff S.[_2_] is offline
external usenet poster
 
Posts: 6
Default Paste from other sheets to below current text

I'm trying to copy text from other sheets (Dir) and post below current text
(Temp) if there is any. I keep getting errors. What am I doing wrong?

If DirectorBox = True Then
Application.CutCopyMode = False
Worksheets("Dir").Activate
ActiveSheet.UsedRange.Copy
Worksheets("Temp").Activate
If Range("A1") < "" Then
Range("A1").End(xlDown).Offset(1, 0).Select
Else
ActiveSheet.Cells(1, 1).Select
End If
ActiveSheet.Paste
End If