resize

I have a spreadsheet that has product pictures and data like sku's, cost, etc. But the person who created it did not format the pictures to move and resize with cells. Can I correct all pictures via a macro? Don't want to do hundreds of manual corrections.

Hi! The following works great. But I want to resize the shape with ScaleWidth 1.5 befor copy it to new cell. I get error. Please help. Function ShapeAtActiveCell() As String Dim Sh As Shape For Each Sh In ActiveSheet.Shapes If Sh.TopLeftCell.Address = ActiveCell.Address Then...

Hi All, I would like to resize all the named ranges on a worksheet, where I have about 30 columns next to each other, so the LastRow of them is the same. This is actually a table, where sometimes a new row will be filled in completely. That is why I need to enlarge all the named ranges (all...

I'm trying to create a spreadsheet for a client that will automatically size itself to a specific size when it is opened. I've googled a dozen things, none of which seem to work. The most common seems to be this code: Sub SetWindowSize1() Application.WindowState = xlNormal...

Hi All, This post will help me understand the use of offset and resize hopefully. I have a range ("C8:C31") containing names and designations of employees.For first emp the name is in the range "C8" & and designation in Range"C10" and it goes on till C31 for other employees.This means that one...

Hi all, I have a set of inventory workbooks (20 different files with the exact same layout and sheet names) with command buttons on the individual sheets to run macros. I have tried every possible solution that I can find online to prevent the buttons from being moved and resized (don't move or...

So, I want to be able to click a button that will open a window and let me Navigate to a location where pictures are located, then when I select the picture I want, I want it to insert it in to an excel worksheet and resize it at the same time. It does not have to be a certain cell that it puts...

I am New to the Forum. On the Bottom Right of Table, I am dragging the corner up to resize the table numbers of rows because of unused rows in table But all the the Table Format/Style remain on spreadsheet Also, formulas from cell table remain on spreadsheet too. I need to manually clean the...

Hello Im trying to resize the chart area width and height using vba,but keep getting “shape is locked and cannot be resized” error. I am using basic commands such as: With ActiveChart .ChartArea.Height = 200 .ChartArea.Width= 50 End With Any way to work around this lock error? Thank you

Hey guys, how you all doing... I have a question. How do i paste an image ( for example in cell A1) and automaticly resize cell to fit image Thanks

How can I resize hundreds of pictures to the same size at once?

I have a fairly complex ribbon tab for an application that looks quite good when viewed fullscreen on a 1024x768 display. But as soon as the window size gets smaller than that, all of the groups in the tab collapse to icons that must be clicked to display the controls. The default ribbon tabs...

Hi, What I’m trying to achieve is if I was to google image a picture and the copy it, I want my macro with CTRL E to paste it into selected cell and then resize it to 3.77 cm height and 2.37 cm width. Thanks

hi guys.. i need your help .. i have extract/insert picture 4 pic from a folder in cell then i want that 4 pic can automatically resize and placed in cell star row from 84 to 87 (4 box cell) my arrow i hope can be explain.. this my file : https://app.box.com/s/via1y8c2asfabjbltwqmyjxujlxbx2x9...

Dear Experts, I have a table and I wanted this to print on a letter head size paper with a 3.5 width by 10 height center to the paper. Also need table to auto resize if I add / delete rows. How can I achieve this. Adjusting the margins, will get me this size? Thanks and regards Eshu153

Hello, I am trying to copy cells from one tab to another as a picture. It copies as a picture, but won't resize. Code gets an error after pictures.paste Thanks in advance. Application.CutCopyMode = False Worksheets("Orig-Plant").Activate ActiveSheet.Range("B2:N67").Copy...

I've been having this problem for years, that on pressing, my Form Controls and Active X controls (when used on a sheet, not in a UserForm) resize themselves, to the point that after a few presses, the size of the control is far larger than originally set, the font of the text increases as well...

Hi, I have the below code. I need to resize this to exclude the last row. In other words I want to keep all but the last row selected. Range("A3:B3").Select Range(Selection, Selection.End(xlDown)).Select I've tried various offsets and resize combinations and can't seem to get it...

I am working on a workbook that uses the following piece of code: <code class="vb keyword" style="font-size: 16px; white-space: pre; box-sizing: content-box !important; font-family: Consolas, "Bitstream Vera Sans Mono", "Courier New", Courier, monospace !important; border-radius: 0px...

I'm using a query to dynamically populate a defined table in Excel. I'm trying to re-size the table to the last non-blank row, without success. I'm getting stuck on detecting the non-blank row. Here's what I've tried (two different approaches), both find the last row the table is set to, which...