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...
(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...
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!
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...
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...
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...
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...
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...
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.
I am waiting for help from you dear wise people.
1 - site (Pega Air Springs - PEGA Otomotiv A.S.)
Example link: Pega Air Springs...
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...
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 =...
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...
I have a macro that fills a textbox with a picture from a URL and aligns the textbox to a cell.
Dim i As Long, URL As String
Dim oTextBox As TextBox
For Each oTextBox In ActiveSheet.TextBoxes
i = 2
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...
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...
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...
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...
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...
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...
I am obsessed with terse code. The code below does the job (I recorded this macro):
Can someone help me clean this up and turn the three lines...