Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi, is there any chance of someone amending this code to have cell X25 form a
list down column K on the 'graphs' sheet, i basically want to duplicate what this code does but add in one more cell, thank you Private Sub Worksheet_Calculate() Dim Dest As Range With Sheets("graphs") Set Dest = .Range("A" & Rows.Count).End(xlUp) If Range("V17") < Dest Then _ Dest.Offset(1) = Range("V17") End With End Sub -- thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Amend Formula | Excel Discussion (Misc queries) | |||
Amend year | Excel Worksheet Functions | |||
Amend the DV0022 - Update Validation Selections code for more lists | Excel Worksheet Functions | |||
amend formula | Excel Discussion (Misc queries) | |||
how can I amend my address data source | New Users to Excel |