1. Jyggalag

    Refer to range in VBA Excel (macro)

    Hi All, I am having an issue in Excel. My current setup looks like this: However, if I put range("O2") it works fine and it sends out the email to my email address. But once I try to increase the range and make it send out to multiple emails, it comes with the following error (highlighting...
  2. Jyggalag

    Send out email through VBA and Macro in Outlook

    Dear all, (Please note that I am using the Outlook program in Windows). I currently have a setup that looks approximately like this (please ignore the snippet on the right side, it is purely to show what an email looks like in an outlook format): I was wondering if it would be possible to...
  3. X

    HELP - Dashboard Objects are Randomly Resizing on a Data Refresh!

    Hey everyone, I don't use Excel a lot, so I am quite proud with what I have come up with. Wish I could share it but it has all my financial data and crypto holdings to create a dashboard. Power queries, just trying to solve a different issue at the moment with VBA, the lot! Besides the...
  4. P

    Multi pictures insert in square shape with macro

    I want to create a macro that look a specific cell and find the picture with the same name in one particular folder and insert it into a specific shape. For exemple, I want the macro to insert the picture that is called PIC1 from the dedicated folder in the first square, the picture that is...
  5. A

    Move shapes to match columns when dates change in cells (VBA)

    Hello everybody and thanks in advance for any help you can provide. I am quite new with VBA so I am not sure how to even start with this. I know there are similar requests in the forum but I am not sure how to make those answers solve my problem. What I need is to use VBA to make the blue...
  6. R

    Prevent shapes from being moved into certain cell

    I've build a planboard and I'm using shapes to represent work packages. Users can move around the shapes and below code would return the first and last cell the rectangle is placed in. Now I want to prevent that the users can move the shapes to certains cells (or the other way around : make...
  7. R

    Move (grouped) shapes based on cell value

    Good morning, For our local football club i'm responsible for planning of the pitches on saturday mornings. The football asociation sends me a schedule on a weekly basis which includes an initial planning of all matches (teams, lockerrooms, fields, starting time) and which I want to reschedule...
  8. P

    Shape Grip Handles too big

    I work with shapes all the time. In earlier versions of Excel, the handle thingies (grips???) on the shape were reasonable size in comparison to the given shape. They allow you to rotate and grab the shape. But with 365, the grips are huge. Is there a way to adjust the size of these extensions...
  9. E

    Retrieving Product Pictures and Tabular Data from the Website

    Hello to everyone, I have a few different websites, I want to extract data from them and then create data for my business and analyze. Link Macro.xlsx I am waiting for help from you dear wise people. My demands. 1 - site (Pega Air Springs - PEGA Otomotiv A.S.) Example link: Pega Air Springs...
  10. M

    Position and Resize Rectangles Dynamically, Based on Cell Values

    I've been working on this all day and have had zero success. I want to be able to change dates in Columns A and B and have rectangles position and lengthen themselves accordingly, based on the calculated values in Columns C and D. I almost had something working earlier today but it would only...
  11. A

    My delete picture code doesn't work

    Hi everyone, I used some codes to insert a picture in a sheet. Then later I want to delete it, but leave the command button. I tried 3 different codes but none of them works. This one doesn't do anything Dim Pic As Shape For Each Pic In ActiveSheet.Shapes If Pic.Type =...
  12. K

    Loop Shapes and Hide if Value/Text is Zero

    I am trying to create a sheet to print scales and chords for guitar students. I am having trouble hiding shapes on the fretboard based on the value within the shape. There are 224 shapes on the worksheet. Each shape is linked to it's own cell on a separate sheet. I figured out how to hide a...
  13. V

    Bug? Aligning Shapes to Cell dimensions is now not and exact match?

    Hi all, I have a macro that fills a textbox with a picture from a URL and aligns the textbox to a cell. Sub FillPic() Dim i As Long, URL As String Dim oTextBox As TextBox For Each oTextBox In ActiveSheet.TextBoxes oTextBox.Delete Next oTextBox i = 2 Do While...
  14. L

    Conditional Formatting Shapes that contains specific words

    Hi to all! My question regards a vba code. How to conditional Formatting Shapes in a sheet? I have a product list on sheet1 Many shapes on sheet 2, linked to every cell in sheet1 that contains that product name. I need to color the background of every shape, if they contains the word for...
  15. M

    Keep source formatting when pasting ranges to a shape

    Hi all I have a workbook with 2 different worksheets. In the first worksheet you type in different information. When clicking on the other worksheet the data from the first worksheet is then copied and pasted into shapes in the second worksheet. I have a challenge of keeping the source...
  16. W

    VBA to change multiple shapes color in Excel

    I'm beginner in Excel so i'm looking for a way by which if I type yes in a cell it should change color of multiple shapes with same color and if I type NO it should remove the color from those shapes and same goes for other zone entries as show below image. Example: If i type On in G22&25 it...
  17. D

    VBA Loop Though Column of Data, Select Shape in offset column

    Hi. I'm trying to figure out how to loop through column "I" If it finds a cell that is blank, skip the row, move to next row until it finds a cell containing a value Once it finds a cell with a value in column "I", select the picture in column "B" of the same row. Once the picture is selected...
  18. A

    How to disable shape copy paste with vba in worksheet - please check this

    i have few flowchart shapes in excel sheet. which i use for label designing purpose. but i don't want to allow user to copy paste selected shape object in same worksheet. Application.copyObjectsWithCells = False Application.CutCopyMode = False The reasons for not allowing copy paste to...
  19. P

    VBA to create, place and name Shape from Values in cells

    Hi, I need help with this: In cells A1:A6 I have Name of Shape In B1:B6 I have refference to another cell in form D2 in cell B1 , E3 in cell B2 , C6 in cell B3 and so on. I need to create multiple Circular Shapes named after A1:A6 and placed into refference cells, which is in B1:B6 and loop...
  20. G

    Convert a shape (group) into a picture inside wrksheet using VBA

    I am obsessed with terse code. The code below does the job (I recorded this macro): Sub copy_and_paste_as_picture() ActiveSheet.Shapes.Range(Array("Group 5")).Select Selection.Copy ActiveSheet.Pictures.Paste End Sub Can someone help me clean this up and turn the three lines...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
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 "".
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