Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can anyone point me in the right direction please?
my code writes a changing calculation value to another part of my
spreadsheet. I am trying to amend my code to paste to another worksheet in the workbook and also write to a different line each time the value changes can anyone point me in the right direction current code below Private Sub Worksheet_Calculate() Worksheet_Change Range("$A$2") End Sub Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$2" Then Application.ScreenUpdating = False With Sheets("sheet1") ..Range("A22").Copy ..Range("F2").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End With Application.ScreenUpdating = False End If End Sub thanks Jonathan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
Direction | Excel Discussion (Misc queries) | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
I need direction | Excel Discussion (Misc queries) | |||
tab direction | Excel Programming |