Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help, Code Locks up
Can someone tell me what is wrong with this code? My attempt is what Cell C6
equals a specific object name; a range of other cells will equal the value of another cell. I can get it to work; this issue is that is only works once. When the program runs, it works as plan but locks up excel and I end up having to go through "Ctrl+Alt+Delete" in order to have access to my computer again. Here is my code: Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If Range("C6") = "Object Name" Then Range("H6").Value = Range(Q6) Range("L6").Value = Range(R6) Range("C8").Value = Range(S6) Range("H8").Value = Range(T6) Range("L8").Value = Range(U6) Range("C10").Value = Range(V6) Range("H10").Value = Range(W6) Else Range("H6").Value = "" Range("L6").Value = "" Range("C8").Value = "" Range("H8").Value = "" Range("L8").Value = "" Range("C10").Value = "" Range("H10").Value = "" End If End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2003 excel locks up | Excel Discussion (Misc queries) | |||
Save as locks up Excel | Excel Discussion (Misc queries) | |||
Excel locks up when trying to save | Excel Discussion (Misc queries) | |||
Autofilter Locks??? | Excel Worksheet Functions | |||
pcanywhere locks up excel | Excel Discussion (Misc queries) |