image

I have used the below VB code to copy a range from my excel sheet to create an image file which I then add to the body of an email: Once the file has been created it then sometimes displays the image but more often than not it comes back as blank showing just a border; can anyone advise on how...

Hello, I am trying to create a salary table to upload to a fantasy sports site. In order to do this quickly, I need to find a way (if it's possible) to automatically fill in values from one list to another. In the image attached, I would like to compare Column C and Column J. If a name in C...

Hi, I'm having a major headache right now and can't think straight on this. I've tried a couple of solutions, but still can't wrap my head around what is needed. Basically, I am trying to return a value from the first tab contingent on whether or not the value underneath cell A1 on that tab...

I'll use a macro to display several images in a worksheet. Then I'll enter some data in worksheet cells. After that I'll trigger another macro to delete the current images and then trigger the first macro to display a new set of images. All of this works fine. What I'd like to do now is...

I am using Excel VBA to copy some cells containing text (with formatting), copy them as a picture, paste the picture into a chart, export the chart as a .jpg file, and load the picture into a UserForm. This works beautifully when I use my home computer to remote desktop into my work computer...

I work regularly on a particular type of Excel document that requires me to insert images so that my colleagues can understand what I'm referring to (related to mechanical design and a picture speaks a 1000 words as they say). In order to keep the document neat and tidy, I insert comments and...

Hello all, I am new to coding VBA and I am stuck on two aspects of the code. I am trying to insert an image under data that is on the excel sheet(the image is coming from a file on my computer), automatically delete the previous image without deleting a logo that is on the worksheet, and...

So my code currently works like this: - User clicks insert button - Button launches a file browser - User selects file (an image) - The code assigns a variable (filename) to the file path - It then inserts a rectangle shape on the last empty row - The image fill is made to be the image...

How do I write code if I have the sellers’ names in column A, and I want corresponding cell values in column B to format grey if I at some previous point in time have marked a name in column A with an X in column C. So, the same name can appear more than once but I only want to mark a name...

H Guys - I have this code that deletes any images on the worksheet and then takes the url address in A2 and displays the image from the address 4 columns to the left. Public Sub Add_Images_To_Cells() ActiveSheet.Pictures.DELETE Dim lastRow As Long Dim URLs As Range, URL As Range...

I have a rectangle with an image fill on sheet 1. On sheet 2 I have images that aren't a shape, they were just drag and dropped into Excel, but they are located within the cell borders I'm trying to figure out the code to take the image from a specific cell on sheet 2 and replace the shape...

In my spreadsheet, the VBA is set to display & resize an image in D4, based on the values entered in A1 (w) and A2 (h), this is the code used: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$A$1" Then Shapes("Group 10").Width = Target.Value / 10 End If If...

Hi all, Had a bit of a google but not sure if this is possible or not... I have a sheet that imports data that is copied to the clipboard from another sheet... the other sheet data will open in protected view - so if people don't click enable editing then it copies the selection as an image...

Hi, Harder than it should be. My code is below but im being told to remove the forward slash. Please advise the correct way to open my image using the path shown. Thanks Private Sub Flag_Click()ActiveWorkbook.FollowHyperlink Address:=C:\Users\Ian\Z THE REMOTE DOCTOR\database-logo\flagg.jpg...

Hi All, I have the below code to insert images into my worksheet from a URL; however, it doesn't save the image with the workbook/worksheet - I need the code modified below so that it saves the actual image with the worksheet and displays it if I share the file with someone else. Help! :)...

Is there any way to include an image in a posting? I know that I can upload the image to a file-sharing website and enter its URL in the posting. I would prefer that the image appear within the posting when the webpage is rendered, without the reader having to click on the URL.

<tbody> First Name Last Name Email New FN New LN Laura Hale, PhD laurahale@gmail.com Prof Marcus Cvija cvijam@yahoo.com Ms Diane Stuart diane88@gmail.com Rey Torres rey.torres@yahoo.com Sam Harris, MBA sharris@gmail.com </tbody> Hi All, I would like to ask for help. I need...

I'm doing a very simple report. I have a bolean field that I converted to 0 and 1 using sql CASE. In the virtual view is defined as an Int. When I create the Crosstab, the values column is the column RevSup that I converted to 1 and 0. For some reason is not summing all the records that it...

Hi, i'm looking to find the sum of two columns (that are not next to each other) based on the conditions of a third column. I am trying to do a final report of finances based on cost centres (in the third column), and the amounts are in two columns, cash and bank. I'm not sure how to attach...

I add a image as a header and I have white gridlines appearing throughout the image. If I add the image just as an image, it is fine but if added through the insert header, it has the lines through it. How do I get rid of them?