VBA Adding Prefix characters to variable

Hi all,

The following is an extract of VBA code I have which reads and stores a cell value, and then the variable SiteNo takes the first 5 characters. These two variables are then written into Master_Sheet:

Please Login or Register  to view this content.

This works fine, but I'd like the SiteNo value entered into Master_Sheet to have the digits "4500" before it.
So, say SiteNo was 10949, I'd like the value in Master_Sheet to be 450010949.

This must be very straight forward but I'm having no luck with either of the following:

Please Login or Register  to view this content.

Any help would be great, thanks!

Hi Rory, thanks for reaching out. I've just realised that VBA didn't like that the integer value of SiteNo was now a string of "4500" and the integer. Changing Dim SiteNo As Integer to String has fixed the problem! Thanks for your time