resize

  1. P

    Resize and Move to Fit

    Hi everyone, I'm not sure if this is even possible but it would be awesome!! Is there a vba code to select all pictures and textboxes *only* and rearrange, resize to make all of them fit on the Excel sheet without overlay of each other or overlay of text in column A?
  2. A

    Cell Formatting

    When working in a cell when using WRAP TEXT, is there some way to tell or have the text automatically resize the cell row heights so I do not have to resize the Row Heights every time?
  3. T

    Vba to tell me what cell in range has the most letters

    Hi Everyone, I'm trying to makea grid area where every cell is the same size, I have 500 cells and keep finding when I resize some text in some cells is missing is there a macro I could run that would tell me which cell has the longest amount of text? Thanks Tony
  4. L

    Open Window in Excel locked

    Why when I go to the open command in excel the window is full sized. I cannot resize it or minimize it. The excel window itself I'm able to resize or minimize, but the minute i click open the window locks - I can't resize or drag it. Any idea why? It's really annoying when I'm trying to...
  5. C

    Resize a pivot table that has a distiinct counts field

    How do I resize a pivot table that uses distinct counts
  6. C

    Icons detached from SmartArt, work-around?

    Hi, I have formed a process using SmartArt and would like to add icons to the chart area, which works fine! But, when copying or marking in order to move or resize, icons are not following. Is there any work arounds on this issue?
  7. A

    VB Code to resize an image

    New<article>This code I am using but the issue is width of picture, it is not fixing in A34:C34 and stretching it all the way to Column P Please please help Sub GetPic() Dim fNameAndPath As Variant Dim img As Picture fNameAndPath = Application.GetOpenFilename(Title:="Select Picture To Be...
  8. S

    Formatting Subtotal Rows - Resize Range?

    I am trying to figure out how to resize a range so I can format subtotal lines via a loop. I have no problems with the loop but I am really confused on how the range resize works. I am searching column F for the word "Total". If that cell contains that word then select columns A to O in that...
  9. T

    VBA Help: Automatically resize all rows containing specific calculated value in a column

    Hello MrExcel community :) I am searching for a solution to resize all of the rows in a worksheet based on the calculated value in column H. I have used column H a conditional formatting helper. In this case, the only two values in column H are "None" and "Color". These values are being...
  10. M

    Resizing Right Brace using VBA

    Hello, I have a stacked bar chart in Excel with a Right Brace for two of the 4categories. Is there a way to automate the resizing of the Right brace to matchtwo of the four categories? As I mentioned it’s a stacked bar chart. Categoriesare Red, Blue, Green, and Yellow. The Right bracket is...
  11. B

    Resize selection and copy it to another workbook

    Hi, i use excel macros about half a year and 99% of them I created myself, but now I'm stuck. ( I have about 30 macros ) Problem : I need to copy only some rows from my chart to another workbook. I hold CTRL and select for example B2 B6 and B10 then i need to resize selection by 8 columns...
  12. S

    Resize from i based on adjacent column value!

    I have a piece of code that I written that searches column O for a value of 1 and when found it checks the value in column N [offset(-1,-1)] to see if matches certain criteria. If does not then the range is resized to 6 rows cut and then pasted after the first example of a 6 is found in column...
  13. E

    Resize a picture of excel chart and paste into word

    Hi, Hope you can help. My VBA code copies excel charts and then pastes into word doc which has bookmarks. How would I resize the copied chart after it is copied so that it will fit in the area of the doc? Sub Chart_copy() Dim wdApp As Word.Application Dim wdDoc As Word.Document Dim...
  14. P

    Resize

    I don't understand why I can't resize the selection!!! I figured since HDR2 is a range variable I would be able to just reference the variable object, select it and resize it. I would have thought it would just be HDR2.resize(0,-2).select But I keep getting "Application-defined or...
  15. S

    Resize picture to fit the image control in userform

    I have an image file in JPG format, 8MB in size. When I try to load this into an image control of a userform, the picture is not scaling to the image control size, despite all values of the options of "PictureSizeMode". The picture seems to be much bigger beyond the size of the image control and...
  16. X

    Auto-Size Pasted Picture/Snippet to Fit Cell Height and Width

    I’m trying to create a set of flashcards in Excel that utilizes a named range lookup for the active flashcard (one example here: https://youtu.be/rTyZmSHDLBA), which works fine. If the image is larger than the referenced cell being looked up, then the named range formula doesn’t work...
  17. M

    Pivot Range has changed?

    Hi Not sure how else to find out other than asking on here. Ive inherited a report which im currently fixing as the pivot tables have all decided to resize themselves and instead of looking at the full range of data has changed to only 2 columns. Anyone know why this might have happened? Thanks
  18. P

    VBA Resize a powerpoint slide that is copied into outlook email body

    Hi all, I have a macro that creates multiple emails and copies a powerpoint slide into the body of each email using the "Getinspector.wordeditor" function. Im now trying to resize (make bigger) the slide that gets pasted into each email body. Any help would be greatly appreciated! Thanks...
  19. L

    shape gets resized if it gets outside of sheet

    Hello friends, i need your help, i have searched all topics and could not still get to solution First of all i want to mention that problem happens with me on all excels later then 2003 on all PCs . now the problem: when you insert autoshape via macro or via INSERT Tab (any size any shape)...
  20. P

    Need macro to change size, position

    I have a macro to resize and position the image in the powerpoint slide. This macro resize the image across the slide the same. Now I have to resize the image differently by each slide. Can you please someone help me how I can do that. <colgroup><col></colgroup><tbody> Sub Pix_Resize() Dim...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top