VBA Concatenate

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

I'm trying to add a title to a particular cell, in this case cell B5, where the value is a combination of text and a cell value.

I wasn't sure how to do this, but after searching various online pages I've come up with the code below:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Unfortunately though, this isn't working, and I recieve an error on this line:

Please Login or Register  to view this content.

I just wondered whether someone may be able to look at this please and let me know where I've gone wrong.

Many thanks and kind regards

[romperstomper]

Remove the .ActiveCell part and one of the closing parentheses. Do you actually want a formula in there, or a value?

[hobbiton73]

Hi @romperstomper, thank you very much for taking the time to reply to my post.

I'm actually wanting the value in the cell please.

Many thanks and kind regards

Chris

[romperstomper]

Then replace this:

Please Login or Register  to view this content.

with this:

Please Login or Register  to view this content.

I assumed you wanted the formatted value of B3. If not, use .Value rather than .Text at the end.

[Hawkeye16]

nevermind, this is already answered

[hobbiton73]

Hi @romperstomper, thank you very much for this, it works great.

All the best and kind regards

Chris

[romperstomper]

Chris,
Glad to help.

[hobbiton73]

Hi @Hawkeye, thank you for taking the time to come back to me with this. It is greatly appreciated.

Kind regards

Chris