I have a macro that creates a template. I now want the logo on the sheet in A1:F1. Is there a way to insert a picture, pointing to the path for the .jpeg and have it automatically sized to that range? Is it easier to just manually create the template, save it as a template file and instead of running that macro just add the template sheet when necessary?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
inserting an image through vba
- Thread starter dinotom
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
You need the full path including the file name. Why did you change this?
to:
Code:
Set Pic = ActiveSheet.Pictures.Insert(PicName)to:
Code:
Set Pic = ActiveSheet.Pictures.Insert(28032011764#)
Upvote
0
Excel Facts
Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
