Macro runs fine on my PC, however when running on an external PC, I receive the error '#NAME?' in all cells

[j4ttlife]

Hi,

In my macro I added a CONCAT formula where cells in column A merge the contents of columns AG, W, and BT.

It runs fine on my PC with the CONCAT in column A showing the combined data, however when running on another PC I am met with the error '#NAME?'.

My code is as below:

Dim LastRow1 As Long

Dim formul3 As String

formul3 = "=CONCAT(AG1,"" "",W1,"" "",BT1)"

Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row) = [formul3]

LastRow1 = Range("B" & Rows.Count).End(xlUp).Row

Range(Range("A1"), Range("A" & LastRow1)).FillDown

Is anyone able to identify what part of my code needs to be changed to enable the macro to run across all PCs? Thanks.

 

[Fluff]

How about

formul3 = "=AG1&"" ""&W1&"" ""&BT1"

 

[j4ttlife]

How about

formul3 = "=AG1&"" ""&W1&"" ""&BT1"

Thank you Fluff, will test this later and let you know if it worked

 

[Fluff]

Ok,

 

[j4ttlife]

Ok,

All good, appreciate the help!

 

[Fluff]

You're welcome & thanks for the feedback.