Hi all.
I currently have a workbook that if column B gets edited/activated, the sheet calls a macro that updates the formulas in column D
This is the current code, which suites are needs:
The actual formula it copies down is =Q9+X9, =Q10+X10 and so on, all the way to =Q1993+X1993
I now have a requirement that I need to put the letters "inc" into column D. However when I type this into the cell then activate a random cell in column B, it calls the macro and overwrites all the "inc"
Is there a way to exclude the cells in column D that contain "inc" from being overwritten when the macro is called?
Many thanks.
I currently have a workbook that if column B gets edited/activated, the sheet calls a macro that updates the formulas in column D
This is the current code, which suites are needs:
Code:
Range("D9").Select
Selection.AutoFill Destination:=Range("D9:D1993"), Type:=xlFillValues
Range("D9:D1993").Select
The actual formula it copies down is =Q9+X9, =Q10+X10 and so on, all the way to =Q1993+X1993
I now have a requirement that I need to put the letters "inc" into column D. However when I type this into the cell then activate a random cell in column B, it calls the macro and overwrites all the "inc"
Is there a way to exclude the cells in column D that contain "inc" from being overwritten when the macro is called?
Many thanks.
Last edited: