I've been using excel for about 20 years off and on and been a member to this site for over 10 years. I've also taken a couple classes but this has me stumped. I'm reaching out the the greatest excel minds on the internet. I have a spreadsheet with a picture in cell A1. This picture is locked in the cell and set to move and size with cell A1. I want to have a formula in Cell
C1 (and other cells) that will show this same picture. This way I can change the picture in A1 and it will also change in the other cells. I've tried =(A1), =Cell(A1) and it still returns a '0" . I've searched and searched but can't seem to find an answer. I have changed cell C1's size to make sure the picture does resize so I believe it is locked in the cell. I can also copy row 1 and paste it and the picture is also pasted. Help!!!!!! I know it can't be this hard.
Darvin Cloin
Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
The Camera Tool did the trick. Never knew it was there. I appreciate you taking the time to respond.
- #4
It is one of Excel's best kept secrets!
Thanks for the feedback
Sometimes, you may need to copy all embedded images in an Excel worksheet to an Outlook email. At this time, you can read this article. Here we will introduce you 2 quick methods. It is easy to copy an image from an Excel worksheet to an Outlook email. You can just select and press “Ctrl + C” to copy this image. Yet, if there are a lot of images to be copied, copying one by one is undoubtedly a stupid and tedious way.
Hence, here we will introduce you 2 much more effective ways. Now read on to get them in detail.Method 1: Select & Copy All Images in Excel Worksheet Manually
Method 2: Copy All Images from Worksheet to Email with VBA
Sub CopyImagesToMail()
Dim objWorksheet As Excel.Worksheet
Dim objOutlookApp As Object
Dim objMail As Object
Dim objMailDocument As Object
Dim objShape As Excel.Shape
'Get the specific worksheet
Set objWorksheet = ThisWorkbook.Worksheets(1)
'Create a new email
Set objOutlookApp = CreateObject("Outlook.application")
Set objMail = objOutlookApp.CreateItem(objOutlookAppobjMailItem)
objMail.Display
Set objMailDocument = objMail.GetInspector.WordEditor
'Copy images to the email
For Each objShape In objWorksheet.Shapes
objShape.Copy
objMailDocument.Range(0, 0).Paste
Next
End Sub
- Next, press “F5” key in the current macro.
- At once, a new email will be displayed.
- Here
you may receive a warning, in which you should click
“Allow”.
- Eventually, all the images in the specific Excel worksheet will be in the email body, as shown in the following
screenshot.
Look out for All Risks around Outlook
Outlook is susceptible to corruption in that there are too many threats around it, such as virus, system failure, hardware faults, and power issues and so on. Hence, it is necessary for you to watch out for all these dangerous factors. First of all, you should never readily trust in emails from unknown senders. Besides, you’d better keep backing up your Outlook file periodically. Last but not least, in order to fix PST file in time, you ought to prepare a cutting-edge repair tool, like DataNumen Outlook Repair.
Author Introduction:
Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including corrupt sql and outlook repair software products. For more information visit www.datanumen.com