offset code

I have a worksheet change macro that both updates an offset cell value with a date & a selection of cells with corresponding offset dates, however I am trying to update it so that it only inputs date if the offset cell is blank. Here is the code that works: Private Sub Worksheet_Change(ByVal...

Would appreciate very much if anyone could help with this code. It does not work at all. Also, it needs to work in newly created monthly worksheets - should it be in a module? Private Sub Worksheet_Change(ByVal Target As Range) Dim myRange1 As Range Dim myRange2 As Range 'MOVE ACTIVE CELL...

Hello Everyone, I have a column with a drop-down list of staff to select for a particular task (starts in H3) I have the following code programmed so that after the Employees have been assigned, management can run the macro to change the employees initials from the drop-down list, into an...

Hello, I'm new to VB and was looking for some help, any input would be greatly appreciated... the cells A1 to H1 contain a bunch of values: 1 11 59 35 33 46 12 18 I need a code that allow the user to add a number to that list and also specify where it goes.. B3= what number to add B4=...

Good Afternoon, Thanks in advance for any assistance that can be offered, now on to the dilemma. Background: I am trying to create a dynamic repeatable formatting process. I have an ever changing list of metrics that are either populated with a value or not. Each metric with a value has a...

I have a worsheet labeled "test". In column A1 through A100 I have codes such as A1=00100, A2=0230, etc. I am looking to use the select case method and a loop to find the various corresponding descriptions that go with the code. So A1 = original code as entered and B1 = description found using...

I have a formula in one cell, and I need to write the code so that it copies and pastes this formula into the 8 cells beneath it without specifying the actual cells. I'm assuming some sort of offset code would work but I don't know where to begin or find this. Thanks!