Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello. I am trying to get an output to a specific cell after change in any
cell in a range. This code does what i want, except it offsets target next to cell. Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Range("h5:h30"), Target) Is Nothing Then Target.Offset(0, 1).Value = Target End If End Sub How can I replace Target.Offset with only one specific cell for all change in range? Thanks in advance :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
In cell drop down menu with seprerate numerical target cell | Excel Discussion (Misc queries) | |||
Go to target cell | Excel Discussion (Misc queries) | |||
In adjacent cell, show last date modified of target cell. | Excel Discussion (Misc queries) | |||
Target value, Next cell | Excel Discussion (Misc queries) |