Thread: Run-Time Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JimFor JimFor is offline
external usenet poster
 
Posts: 31
Default Run-Time Error

Hi,
I'm working on a programa and am trying to move some data from one sheet in a
workbook to another. I wanted to move the data in seven cells from sheet 1 to
sheet 2 Tried doing it with one cell This is my what my instructions look
like:

Sub MySub()
Worksheets(Sheet2).Cells(2, 1) = Worksheets(Sheet1).Cells(2, 1)
End Sub

When I run it I get a Run-time Error 13 Type Mismatch error

Can anyone tell me what that means and what I can to do correct the error? The
cell format is "General." I have nothing else in the program. Just those
lines.

Thanks