images

  1. I

    REF! Error, cant seem to figure it out. HELP PLEASE

    Hi, I have a financial plan that i am working on, unfortunately i am stuck with a REF! error. https://imgur.com/a/uDLJU https://imgur.com/Pn3bE8r Here are some images, can someone try and help me out with this. Thank you in advance
  2. H

    loading a picture from spreadsheet into userform

    Hi, I have few images in a sheet called 'Images'. Once the userform initializes, i want the 1st image (Picture 1) from the 'Images' sheet to be uploaded in the userform. I have written the below code. However getting error. Any help would eb appreciated Worksheets("Images").Select...
  3. E

    Pulling Images from a File Or Folder

    Hi, Is there a formula for pulling images into excel? The images are either in another excel spreadsheet (ie. I could do a vlookup, but to pull the image in) or the images are located in a particular folder. Thank you.
  4. M

    Excel VBA: Inserting Images into documents via Macro and Quality Issues

    ****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;"> <tbody style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: inherit...
  5. didijaba

    Unlinking images in word document after mail merge

    Hi, I'm doing large mail merge with lots of pictures, and I used macropod advices (thanks macropod), but I have problem when I need to send created word document to someone. It has no images. I'm using Office 2016 (Win). Here are my VBA code and formula for placing images. Images, source excel...
  6. F

    Images and slicer

    Hi everyone. I don't know if this is possible but thought this would be the place to find the answer! I have a table with 4 columns and 30 rows, and one of the columns is for images (so an unique image in each of the 30 cells). Is it possible to have a slicer display the text in the first...
  7. A

    VBA Insert images

    Hi All, Been looking around the site, tried a few things and can't find a way to get this working So time to ask for some help / establish if what I'm trying to do is even possible :eeek: So, I am looking for a VBA Macro that will insert the latest image from a camera directly into excel -...
  8. J

    Auto fit images in existing cells in a Column

    How can I auto fit images in existing cells in a Column ?
  9. I

    VBA: How to crop image in cells of column B and save it in a folder with names from column A cells.

    Hi, I have Column A with image names and column B with images. How can crop images (Up=0.5 cm , down= 0.6 cm, left = 1 cm, Right 1.5 cm) and save the images in a folder with file names in respective rows. Some cells can be blank in between. I have 1.5 k rows.
  10. L

    Best Way To Delete All Shapes And Adjacent Cell?

    If I have images through B1:B10 and values in A1:A10, what's the best way to delete all images and left value whilst keeping all the values in C onwards to remain in the exact same place? I only want to delete adjacent cell if an image is there so something like this but this really messes up...
  11. A

    Showing images in a cell based on filepath

    Hello everybody, Im really new to VBA and Excel and my question might have been asked like a thousand times, however I still didnt manage to complete my goal. Hopefully you can help me. What I want: I want to show images in a cell based on a filepath. Lets say: A1 = Flower A2 = Dog B1 =...
  12. T

    Selecting shapes and images in specific range, grouping then pasting in a new worksheet retaining group status.

    Hi, I am trying to create a form that people can edit. Users will use various shapes and images in a range to create a diagram and I want to save it to a table in another worksheet. The code below almost does what I want except it pastes the group of shapes as a picture. I would like to be able...
  13. P

    Excel- displaying linked images based on filepath

    I need to have Excel display images based on the file paths from another column. In a certain way: column G shows the name of the folder column H shows the name of the file(usually: 00, 01, 02, ...) column I specifies the filetype ONLY if it is different from .jpg The image should appear in...
  14. I

    How to select all images in a single excel column ? I have images in cells of column A, B and C. And I want to select only c column images.

    How to select all images in a single excel column ? I have images in cells of column A, B and C. And I want to select only c column images.
  15. S

    Excel using RAND functions

    Does anyone knows how to solve the below question???? I've been stuck at this question for WEEKS. Kindly help!!!!! The slot machine is a favorite among many patrons in casinos and private clubs. It has three identical reels, each reel with spots for 64 images.These include cherry, plum...
  16. A

    Save a copy of sheet without macro or formula

    Hi Guys, So I've been struggling with this all day and reached the end of my knowledge as I know there must be a much simpler way of doing it ... Aim Save the current sheet as a seperate workbook with only values, formatting and images i.e. .xlsm to .xlsx (no macros or formulas) Whilst keeping...
  17. A

    Insert specific image from folder

    Hi Guy's..... I'm Stuck!! Basically I am making a template for a report generator. The reports contain several images, the images are stored in a file tree that will be the same for each report just the master folder different. The issue is that the image name is not always the same. I want to...
  18. B

    VBA Named Range Help?

    I have a spreadsheet with a few dynamic images and dropdown lists on Sheet1. The lists are all in column A, and the dynamic images(Picture 1- Picture 4) are all in column B (1 per row). The table of imagesthat acts as the basis for the dynamic images is on Sheet2. I have a namedformula...
  19. R

    VBA to create folders and copy files based on file names

    Hi experts, Hope someone can help with this. I have 10k images named as AA-1000.jpg or AA-1000-10.jpg etc. The important thing is that I want to create folders based on first 2 letters in image names, and move all other images with same letters to the same folder. Basically, I want to run a...
  20. B

    Need VBA Help!

    I have a spreadsheet (I can upload it here, but I don't know how to do it...) where Sheet1 A1:A4 are drop down lists that allow users to select various shapes ("", Square, Circle, Triangle, Rectangle). On Sheet2 I have the same 5 options listed from A1:A5. I also have images of these shapes in...

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