Can someone explain me why the value of RCV_SIZE is as shown in the immediate window?
VBA Problem.PNG
Can someone explain me why the value of RCV_SIZE is as shown in the immediate window?
VBA Problem.PNG
Try changing your ampersands (&) to And
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Welcome to the forum,
I am seriously thinking you're pulling our leg here.
Read you value for the two variables you're concatenating and the final "HR" what else do you expect?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
To clarify, try changing your ampersands (&) to And in the If statements NOT in the subsequent concatenations.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks