VBA To Insert CONCAT For Two Table Fields

[Raddle]

Hi

Could anyone help out with where this is going wrong?

I need to insert the formula to concatenate two table fields. For some reason I am failing to do this using VBA, whilst I can do it directly in the cell.

With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=[@Question]&[@Answer]"

.. just can't seem to find the right combo of quotes / double quotes .. or am I just not in the right direction?

Any help v welcome and thank you

 

[rlv01]

Use a variable so you can inspect the concatenation first and see if what you are trying to assign to the Formula1 property makes sense.

With Selection.Validation
.Delete

Dim FormulaStr As String

FormulaStr = "=[@Question]&[@Answer]"
Debug.Print FormulaStr

.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=FormulaStr

(Tip: For future posts , please try to use code tags like I did above when posting code. It makes your code easier to read and copy.

How to Post Your VBA Code

Post your VBA code.

www.mrexcel.com

)

 

[Raddle]

What a star you are .. that helped me realise that I didn't want validation at all ... I just wanted to put the concat formula in .

Thank you so much

Have a great weekend