Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a Type Error
I am trying to use the following Macro to copydown the Formula = C1 & E1 But I am getting a type error. Public Sub CopyDown1() Range("A1").Select lastRow = Range("A65536").End(xlUp).Row For i = 1 To lastRow If Range("A" & i).Value = "" Then Range("A" & i - 1 & ":A" & i - 1).Copy Destination:=Range("A" & i) End If Next i End Sub What am I doing wrong? The error is: Range("A" & i).Value = Error 2015 -- Pedros ------------------------------------------------------------------------ Pedros's Profile: http://www.excelforum.com/member.php...o&userid=28202 View this thread: http://www.excelforum.com/showthread...hreadid=569240 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
xpath error? Runtime Error 13 type mismatch | Excel Discussion (Misc queries) | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming |