picture

  1. R

    Average function - Cells contain values and string

    Hi. I have searched around the forum and tried to apply various functions to my range, but I can't seem to get it to work. Problem: Average of values in a range of cells containing both strings and values. See picture. https://ibb.co/KrCCBZB Question: What is wrong with my formula? Thanks...
  2. J

    Email and Range of cells including a picture

    Hi All, I'm using the below code to send a range of cells using a command button click, which works as expected, but misses out a picture that I would also like to send: Sub SendSelectedCells_inOutlookEmail() Dim objSelection As Excel.Range Dim objTempWorkbook As Excel.Workbook Dim...
  3. D

    How to paste picture in messages in Mr Excel.com ?

    Hi all, I'm working on a VBA Code which currently allows to display all items of the Listbox from my Userform, I would like to post a picture to describe what I'm writing, but don't succeed to paste any picture :confused:from my laptop. Any ideas ?
  4. F

    ActiveX command button

    I know how to add a picture to the button (manually). Is it possible to create a code that when the button is clicked it changes to a different picture then when clicked again it changes back?
  5. C

    VBA to paste picture into PPT to a designated width or height whilst keeping aspect ratio

    Hi, I have some code which takes a range in excel (which changes in size) and then pastes it into powerpoint as a picture. I need some code that will copy the range and paste it as a picture to a specified width or height (one or the other). Whether the picture is sized to the specified width or...
  6. S

    Formula will type, but appears as a picture

    Hey Everyone! We are working in Excel 2016. When we typed a VLOOKUP into a cell, it turned into a truncated picture. We could type behind it, and type a new formula below it, and could not move the "picture". This file has been used many times and was a one time occurrence. Has this happened...
  7. N

    Dynamic Pictures based one someones name

    Hi all, Wondering if you could help me here. I am trying to create some profiles for some players in which I change the name and their picture changes. I have created a table with their picture next to their name and followed some instructions online to make dynamic pictures however I keep...
  8. D

    VBA to Delete a picture before adding one to target cell

    Hi All I have had some help with another user on how to create a button whereby I could open a popup, select a picture, have it stretched to fix and centered in a cell. However, i just noticed that if there was an existing picture there, it would not be deleted, and the new picture that i...
    • DCGNM
    • Thread
    • .filters.add .width cell pic.width picture
    • Replies: 6
    • Forum: Excel Questions
  9. C

    Email Signature

    Can anyone help i have peaced together the below code through using Google and a bit of trial and error, I have created a macro to send an email based on data in a spread sheet. My problem is the email signature does not display the pictures can anyone help? see below code Dim xOutApp As...
  10. S

    .HTMLBody VBA code to attach a picture (PNG)

    Hi, I’m trying to attach a picture/PNG file to An email via VBAcode using .HTMLBody but want to set the location of picture not within theHTML statement: Currently: .HTMLBODY = "<HTML>******><imgalign=baseline border=0 hspace=0 src='C:\Users\ documents\Reporting\MacroTest\New...
  11. O

    Cell needs to be blank if False

    Hi I have a nested formula but I am not able to get a blank cell if none of the parameters are met? I have attached a picture and the formula is below. =IF(AND(C2<=4,D2<=4),"NUISANCE",IF(AND(C2>=5,D2<=4),"EXPLOITABLE",IF(AND(C2<=4,D2>=5),"DEVELOPMENT",IF(AND(C2>=5,D2>=5),"CORE","")))) Thank...
  12. F

    Using a Macro to open the most recent picture in a folder

    Hi guys & girls, I'm currently trying to create a Macro in Excel that opens the most recent picture (.jpg) out of a folder for me. I'm not bad with Excel, but I've never worked with Macros. Using the most recent office version (March 2019). I found the following code online: Sub...
  13. M

    Aspect ratio of picture changing upon cell height change

    In my workbook, I give the user the ability to insert a picture file into one of the worksheets. I have code that does this for them, so the sheet can remain protected the rest of the time. I also allow them to change the height of one of the rows in that sheet, in case they need a bit more...
  14. J

    Note - Fill Format to show a picture

    Hello Guru(s), In previous version of Excel, you could edit the format of a note to show a picture by changing some settings in the format/fill tab. This latest Jan 31st 2019 release seems to have removed this nice little feature. Any idea how to do this now? Basically any way for a picture...
  15. ajjava

    VBA to create check boxes on top of picture objects, on multiple sheet?

    Our ERP generates reports that contain charts. When the reports are exported to Excel, each chart is rendered as a picture object. I'm looking for a macro that will find each picture object in a workbook and ADD A CHECK BOX IN THE UPPER CORNER. I've added a thick red border around each picture...
  16. M

    Copy Selection as Picture Issue

    Morning everyone. I've arranged a bit of code that filters my workbook, selects a named range, copies that range as a picture, opens up a new email on Lotus Notes (unfortunately), pastes that pitcure in the email's body, along with various other text as well as grabbing recipiants and a subject...
  17. T

    Select the cell behind a shape

    Hi everyone, I would like to have a macro that when I click on any shape in sheet "Data1" it select the cell Behind it, The page is set in such a way that every picture is within a single cell. Please help if you can Thanks Tony
  18. R

    Excel Graph Help

    Hi, I need some help with a graph. If you look at the second line of the data (first picture) - you'll see this is captioned as FS&CM. This is plotted along the bottom axis. But from here, I need to combine KSA / UAE / KWT / GCC in one bar (as per the second picture) .... but what I'm...
  19. berty2000

    Pull picture into userform multipage

    Hi Im trying to pull images from hard drive locations into a userform multipage, but it displays the image behind the multipage. I'm trying to put the picture in Image1 on the userform. This is what i got so far. Sub Addpictures() MultiPage1.Value = 0 Set img =...
  20. T

    vba to make a list of all picture names sizes and sheets?

    Hi Everyone, Not sure if this is posible, but creating a new document with about 90 sheets, every sheet has a picture or two in it, many of which are the same but i'm finding the pictures are not maintining there sizes as i copy paste move design ect. I've done "Do not move or size with picture...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top