size

I am making progress. At the moment I can add an image to a cell, size it to a specific range but thats where I am stuck. Now I would like to be able to select an image in a specific range and change the background colour (white) to transparent. Any ideas? My attempt is in red below...

Hi All I have a sheet where all the rows have a product image. There are quite a few rows so loads of images - all thumbnail size. However, the user often needs to duplicate the sheet in other tabs, so in theory all the images are copied too and my file size gets bigger and bigger! Is there a...

Hi - Been a while, but I'm hoping to find a way to fix a limitation on a reconciliation tool I designed a while back to compare two extracts from an SQL database. In particular I'm having trouble on memory limitations when Resizing a Variant array: ReDim Ukey(1 To MyDict.Count, 1 To ((H - 1)...

I am trying to develop a macro where I will be importing values from one Listobject to another Listobject. Before pasting the values, I need to ensure that the two Listobjects are the same size, i.e. they have the same number of rows and columns. If this is not the case, then the "new...

Is there any way to stop excel from opening subsequent workbooks at the size and or location of the last opened workbook? I wrote a script to open a specific set of data at a specific location and size. I keep this open all day but every time I open anew workbook it snaps to that size/ location...

Good day. I am using Excel 2013 on Windows 10 Pro. I have a workbook that contains 5 worksheets. Each worksheet allows the user to enter data into rows that reach out to Column EA. Column A contains data that is necessary to be visible while entering data out in the far end of the worksheet...

I need to manually select certain ActiveX commandbuttons on a worksheet, and then change its font size. Below is my attempted code but returns error. Sub Testing() Dim o As Variant For Each o In Selection o.Font.Size = 20 Next End Sub Thanks a lot!

So I've got a bunch of comments in a spreadsheet and all the comments are of variable length. I try not to change the size of the default box if I can avoid it cause I've noticed if I increase the size or move it, the next time I look at that comment, the box has changed size and I have to...

Tired sometimes to pull some kind of end! How to make the whole Sheet "Excel" or set the size of 600px. I think the macro might be good! For example: 1) Point at the Cell. 2) Run the VBA macro in which the form appears. 3) In the form enter the desired size in pixels. another... 1) Point at...

Hi Need help with this. I have a range of sizes of pieces of art from 35 inches2 to 352 inches2. I then put amounts of money along side each size. The amount per square inch decreases as the size gets larger. 35 x £10 = £ 350 352 x £3 = £1056 The rates in £'s per square inch between 35...

Hi I have set excel so all new spreadsheets open with same font and size. Where I need help is when I insert a new column into other peoples spreadsheets the font changes and the size increases. I have a spreadsheet with a MACRO inserting a new column and I then have to spend time resizing and...

I have buttons on my worksheet that changes size when they are clicked. What's happing? I do not have any code directing them to. The columns/rows that they are in do not change size so that's not it either. they get smaller when clicked (each time they are clicked) Thank you for your help

Hello all, I've got a load of pivot tables on a sheet and have coloured all the surrounding cells white to make the page look better. However, when I use a slicer to change what the pivots show, when they reduce in size the cells left showing have no fill. I've manually filled them and also...

I know this is simple IF solution, but haven't had to us it in a long time. I need a formula to pull the unit price from another sheet in the same workbook, based on column B and C. I have a tab in my workbook called Product List. It has Size in Column A, Discrition in Colomn B and total item...

Hello everyone, I am developing a VBA web scraping tool that will find all of the size variations for an amazon page and get their ASINs (The unique link to each product page.) Any amazon page will do, but here is the web page I used in my example. https://www.amazon.com/dp/B079M63HK2 The...

Hello everyone, I am developing a VBA web scraping tool that will find all of the size variations for an amazon page and get their ASINs (The unique link to each product page.) Any amazon page will do, but here is the web page I used in my example. https://www.amazon.com/dp/B079M63HK2 The...

Hi, I am currently creating a financial worksheet to use for my clients. I already set the size to A4 so everytime I print it, it will be exactly in an A4 size paper. Now, here is my question can I expand the cells where I am currently working? and then when I have it printed it will still fit...

Hello, I have created very simple form which has only one object: listbox. Strange thing happens. Mostly when I break code execution, but sometimes even a code runs to the end. Size of the form decreases. This self size change causes to autoadjust the listbox, but only its size. Not font size...

A recent issue of Excel worksheets are reduced in size when dragging them across to the secondary monitor requiring the worksheet to be enlarged to it's full size after dragging to the second monitor. I believe this occurred after a recent Microsoft Excel update as this now occurs in my and my...

Hello, I am doing a vlookup between two workbooks in each of four cells (A3 - A6) based on the value in A1. In A2 I have 4 different options that get inputted, separate from these vlookups. What I would like to accomplish is to only show values in cells A3 - A6 based on the value listed in...