VBA: Marco to run on cell change

Hi Everyone,

I have a Marco which runs on a cell and uses text to column to split it twice. I have the below formula run on a button. However, I'd like it to run when cell J15 has changed. Would someone kindly advise on how this might look, please?


++++

Sub PostcodeMover()
'
' Macro3 Macro
'

'
Selection.TextToColumns Destination:=Range("AC42"), DataType:=xlFixedWidth _
, FieldInfo:=Array(Array(0, 1), Array(2, 1)), TrailingMinusNumbers:=True
Selection.TextToColumns Destination:=Range("AC41"), DataType:=xlFixedWidth _
, FieldInfo:=Array(Array(0, 1), Array(1, 1), Array(2, 1)), TrailingMinusNumbers _
:=True
Range("AC27:AC36").Select
Selection.Copy
End Sub

++++

I'm sure it's a really easy fix but I can't say I'm the best with VBA coding etc

Hi,

What's in J15? A formula or a manual entry. If a formula you need to find the precedent (manually changed) cell that causes J15 to change. Then in the Sheet that contains the precedent cell use the Worksheet_Change event macro. Somethig like the following - untested since you've not supplied a workbook

Please Login or Register  to view this content.

Obviously change the Sheet and range references. And simularly for yor second text to columns code.