resize

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?

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?

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

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...

How do I resize a pivot table that uses distinct counts

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?

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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

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...

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)...

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...