KlausW
Active Member
- Joined
- Sep 9, 2020
- Messages
- 403
- Office Version
- 2016
- Platform
- Windows
Hi, I found this code from Barb Henderson.
Works great. j I have a small challenge, in column B, starting with B2 are the names of the images to be imported, for this I use a formula. Sometimes the cell is empty, but there is still a formula in it.
So, I get this error in this line.
ActiveSheet.Pictures.Insert("C:\Users\k-wit\Documents\Rejseafregning\" & pictname & ".png").Select 'Path to where pictures are stored
Someone who can help, all help will be appreciated.
Best regards Klaus W
Works great. j I have a small challenge, in column B, starting with B2 are the names of the images to be imported, for this I use a formula. Sometimes the cell is empty, but there is still a formula in it.
So, I get this error in this line.
ActiveSheet.Pictures.Insert("C:\Users\k-wit\Documents\Rejseafregning\" & pictname & ".png").Select 'Path to where pictures are stored
Someone who can help, all help will be appreciated.
Best regards Klaus W