resize

  1. D

    Insert a picture into named excel worksheets by client id vba

    Hi everyone, I have a workbook containing multiple sheets. The first sheet contains a unique 4 digit id to identify the client. Other sheets within the workbook are named after a year group so Y1, Y2, Y3 and so on.... Elsewhere on my PC, i have files that are named with the 4 client digit id...
  2. D

    resize for copy

    how do i adjust the following code to change the copy and paste from Range("A" & i) to ("E" & i ). i get a object doesnt support the property when i change A to E. I tried to do offset(0, 4) and get a "You cannot past this here because the Copy area and paste area are not the same size...
  3. G

    Userforms resizing and reformatting on different monitors

    I have a few userforms on a sheet, but when I use them on a different sized monitor, they resize (often much larger) and the contents are not organized well like I have them set. As soon as I go in the VBA Editor and resize them back to normal, they take on all their old formatting, but I was...
  4. B

    how to use offset range and or resize

    I have a sheet that represents a score card for a sporting event. Row 3 contains the dates of the game, row 4 contains the day of the week and row 5 contains a ‘points’ heading. The remaining rows contain the scores of the games and the team name For example. Row 3 contains 01/01/19...
  5. T

    VBA to resize a range to fit the textbox.

    Hi Everyone, I have a problem, I need people to be able to copy and paste text from Word into excel, I have encounted a number of problems doing this as the people doing the cut and pasting are all at the lower end of the gene pool. So after many hours of testing the only solution I could find...
  6. C

    excel vba resize how can i control the resize and keep specific columns

    So when I import data to my table it often has an erradict and unpredictable amount of columns which is fine except when I want to resize I would like to keep the first 8 columns of the table and delete any of the rest. This works great below except my coulumns seem to keep the last 8 of the...
  7. S

    [VBA] Positioning Chart in Powerpoint after copy pasting from Excel

    Hi, I'm not sure how to refer to a picture of a chart that was copied from excel and pasted into powerpoint. The macro copies 4 charts in total and pastes them into one slide. I looked at the selection panel and they are named Picture 1, Picture 2, Picture 3 and Picture 4. I tried referring to...
  8. I

    Moving ToggleButtons

    Any ideas how to stop toggle buttons from moving every time i open my spreadsheet. I have a few of them. I have grouped them, set them to don't move or resize but they still do it. Many Thanks
  9. M

    VBA Code to resize photo

    Hi is there a code that will resize a photo saved in a fold on my desktop so I can automatically drop it in to a cell that’s already sized say 50 x 50 thank you
  10. E

    Resize Table using values in certain cells

    Hi to all. I ve been searching around but found nothing similar except the code i will paste below (hope to do it properly) What i look for is to resize a table to specific rows and columns. How many rows and columns will be given by values in specific cells. So in the following code i managed...
  11. O

    VBA to Insert Pictures into the Cell based on the value in another coln.

    Hey guys Can someone please help me fix up my VBA code ? :'( Here is my current code: Sub PlacePics() Dim Path As String, Pics As Range, Pic As Range, Pix As Picture On Error Resume Next Path = "C:\Users\Panda\Pictures\" Set Pics = ActiveSheet.Range("A9:A504")...
  12. 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?
  13. 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?
  14. 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
  15. 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...
  16. C

    Resize a pivot table that has a distiinct counts field

    How do I resize a pivot table that uses distinct counts
  17. 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?
  18. 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...
  19. 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...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top