Invalid qualifier

[Robert E Lee]

Hi All

I have set Bcode as String, and have created this string by concatenating the contents of 3 separate cells interspersed with "/".
I now need to copy this string to another sheet but the code fails on the second use of BCode with the message "invalid qualifier"

I am clearly doing something wrong but cannot see what it is

Any suggestions
Thanks
Rob

 

[RoryA]

I am clearly doing something wrong but cannot see what it is

Nor can we without any code...

 

[Robert E Lee]

Fair enough, here is the relevant code

Bcode = NA &"/"& NB &"/"&  NC

Where NA NB and NC are strings formed from the contents of various cells.

The second Bcode is marked as invalid qualifier

Rob

 

[Robert E Lee]

Oops omitted second line of code

Bcode.Copy

 

[Fluff]

You cannot use .Copy on a string, what are you trying to do with the string?

 

[Robert E Lee]

I am trying to copy it to another sheet?
Rob

 

[RoryA]

You can just assign it to the relevant cell on another sheet directly - e.g.:

Sheets("some sheet").Range("A2").value = Bcode

 

[Robert E Lee]

Thank you both for your help

Rob

 

[RoryA]

Glad we could help.

 

[Fluff]

You're welcome & thanks for the feedback