Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying data to another worksheet gives "Type Mismatch" error
I am trying to copy data from one worksheet to another, but I keep getting a
"Type Mismatch" (error 13) message. I've tried a bunch of different ways to code this, but I end up with the same error every time. In desperation, the following was the last attempt: Dim vHours as Integer Dim vdate as Date If Range("C10").Value 0 Then vHours = Range("C10").Value vDate = Range("G5").Value - 6 Sheets("ws2").Range("B" & Range("B65536").End(xlUp).Rows + 1).Value = vHours Sheets("ws2").Range("A" & Range("A65536").End(xlUp).Rows + 1).Value = vDate End If What am I missing? This is driving me crazy. HELP!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when copying from one spreadsheet to another I get "#VALUE!" error,how can I eliminate it? | Excel Discussion (Misc queries) | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
multiple file uploading - runtime error'13': type mismatch "While Counter <= UBound(FName)" | Excel Discussion (Misc queries) | |||
VBA setting formula for a cell causes "Wrong data type" error | Excel Discussion (Misc queries) | |||
Where is the toolbar with the "bold type", "font type", options | New Users to Excel |