target.offset0

Hi I have the following VBA code against sheet 1 and this is working on a single column D4:D100. But now i need to track the date a change to any cell within 4 different columns independently, I can not get this to work. Can anyone help please? I assume I have joined / linked the code...

Hi, I have working code to Lock/Unlock a range of cells based on a DropDown selection ("PASSTHRU") of another cell. When I ADD a line to BLANK each cell (using ="") prior to Locking, I get the error: "Run-time error 1004 Unable to set locked property of the range class" Any ideas? Private...

hi, i have the below code to clear value of Dependent drop downs (C13:C22) when selection changes in parent drop downs(B12:B22) but i have an issue. i have rows with some data above B13 and when there is a change in the any of cell between B1 to B12 the corresponding column values are also...

Hi all, I have a piece of code below which clears of a given row in column J if a cell in the same row in columns G, H or I is changed. Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target.Validation.Type = 3 Then Application.EnableEvents =...

Hi All, I run the following code to capture the current time in certain fields. All that the user does is double clicks a cell to enter the current time. However, if they in error click the field again, then it overwrites the captured time with the current time. Is it possible to exit the...

So I have this code that first deletes any old shapes (if any) then inserts new shape after. this code was not made by me and i'm having some troubles improving it.. originally it work like this: cell G27 has a dropdown list and shape gets inserted into cell f27 , Im trying to get remake the...