I did change the path name to where I had the image and the spreadsheet on my I:drive rather than C drive (in a folder) so I changed the path name to Path = "I:\GHTest\2021 New Products\secondary images\" - was I right to do that (and do I need to add anything to the sourceimage? When I run the VBA it says file not found and highlights Attachment 717850


Sub CreateCopy()
Path = "I:\GHTest\2021 New Products\secondary images\"
sourceimage = "SECONDARYIMAGE3.JPG"

For r = 1 To 10 'or however many there are
FileCopy Path & sourceimage, Path & Range("B" & r).Value
Next
End Sub