Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Problem !
Hi Guys, Can anybody help me with the following piece of code !?. It works to a point, but I keep getting the error message "Type Mismatch, run error 13" after execution. Also if I change any cell on the worksheet the macro executes!, even though i have specified the target cell. Basically the macro should on run based on a value a user enters in "J13". Any help very much appreciated Mike R Private Sub Worksheet_Change(ByVal Target As Excel.Range) Application.ScreenUpdating = False With Application .Calculation = xlManual .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False If Target.Value = "$j$13" Then Range("c13").ClearContents Range("j13").Select Application.CutCopyMode = False Selection.Copy Range("c13").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ Application.EnableEvents = True Application.ScreenUpdating = False With Application .Calculation = xlAutomatic .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False End If End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Problem !
Doesn't the Type Mismatch error give a line
number? That would help narrow it down. Is the Selection.PasteSpecial line correct? Looks like it's missing something after the continuation. -jcf "Mike R" wrote in message ... | | Hi Guys, Can anybody help me with the following piece of | code !?. It works to a point, but I keep getting the error | message "Type Mismatch, run error 13" after execution. | Also if I change any cell on the worksheet the macro | executes!, even though i have specified the target cell. | Basically the macro should on run based on a value a user | enters in "J13". | | Any help very much appreciated | | Mike R | | Private Sub Worksheet_Change(ByVal Target As Excel.Range) | Application.ScreenUpdating = False | With Application | .Calculation = xlManual | .MaxChange = 0.001 | End With | ActiveWorkbook.PrecisionAsDisplayed = False | If Target.Value = "$j$13" Then | Range("c13").ClearContents | Range("j13").Select | Application.CutCopyMode = False | Selection.Copy | Range("c13").Select | Selection.PasteSpecial Paste:=xlValues, | Operation:=xlNone, SkipBlanks:= _ | | Application.EnableEvents = True | Application.ScreenUpdating = False | With Application | .Calculation = xlAutomatic | .MaxChange = 0.001 | End With | ActiveWorkbook.PrecisionAsDisplayed = False | End If | End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Problem !
"Mike R" wrote in message ... Hi Guys, Can anybody help me with the following piece of code !?. It works to a point, but I keep getting the error message "Type Mismatch, run error 13" after execution. Also if I change any cell on the worksheet the macro executes!, even though i have specified the target cell. Basically the macro should on run based on a value a user enters in "J13". Any help very much appreciated Mike R Private Sub Worksheet_Change(ByVal Target As Excel.Range) Application.ScreenUpdating = False With Application .Calculation = xlManual .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False If Target.Value = "$j$13" Then This makes no sense. What are you trying to achieve here ? Keith |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Problem !
Thanks John, code was missing from Selection.PasteSpecial line. -----Original Message----- Doesn't the Type Mismatch error give a line number? That would help narrow it down. Is the Selection.PasteSpecial line correct? Looks like it's missing something after the continuation. -jcf "Mike R" wrote in message ... | | Hi Guys, Can anybody help me with the following piece of | code !?. It works to a point, but I keep getting the error | message "Type Mismatch, run error 13" after execution. | Also if I change any cell on the worksheet the macro | executes!, even though i have specified the target cell. | Basically the macro should on run based on a value a user | enters in "J13". | | Any help very much appreciated | | Mike R | | Private Sub Worksheet_Change(ByVal Target As Excel.Range) | Application.ScreenUpdating = False | With Application | .Calculation = xlManual | .MaxChange = 0.001 | End With | ActiveWorkbook.PrecisionAsDisplayed = False | If Target.Value = "$j$13" Then | Range("c13").ClearContents | Range("j13").Select | Application.CutCopyMode = False | Selection.Copy | Range("c13").Select | Selection.PasteSpecial Paste:=xlValues, | Operation:=xlNone, SkipBlanks:= _ | | Application.EnableEvents = True | Application.ScreenUpdating = False | With Application | .Calculation = xlAutomatic | .MaxChange = 0.001 | End With | ActiveWorkbook.PrecisionAsDisplayed = False | End If | End Sub . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Problem !
Thanks Don, that's what I was looking for., makes
everthing alot easier -----Original Message----- If all you want to do is copy the j13 values to c13 then this will do it. Private Sub Worksheet_Change(ByVal Target As Excel.Range) if target.address < "$J$13" then exit sub [c13].value=target end sub -- Don Guillett SalesAid Software Granite Shoals, TX "Mike R" wrote in message ... Hi Guys, Can anybody help me with the following piece of code !?. It works to a point, but I keep getting the error message "Type Mismatch, run error 13" after execution. Also if I change any cell on the worksheet the macro executes!, even though i have specified the target cell. Basically the macro should on run based on a value a user enters in "J13". Any help very much appreciated Mike R Private Sub Worksheet_Change(ByVal Target As Excel.Range) Application.ScreenUpdating = False With Application .Calculation = xlManual .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False If Target.Value = "$j$13" Then Range("c13").ClearContents Range("j13").Select Application.CutCopyMode = False Selection.Copy Range("c13").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ Application.EnableEvents = True Application.ScreenUpdating = False With Application .Calculation = xlAutomatic .MaxChange = 0.001 End With ActiveWorkbook.PrecisionAsDisplayed = False End If End Sub . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code problem | Excel Discussion (Misc queries) | |||
Alt Code Problem | Excel Discussion (Misc queries) | |||
Code problem | Excel Discussion (Misc queries) | |||
VB Code Problem | Excel Discussion (Misc queries) | |||
Little problem with this code... | Excel Discussion (Misc queries) |