resize

Hi, I currently have a worksheet that changes range and zoom when opening on different resolutions on different computers. How can you have a script that automatically resizes all worksheets to the same cell range when the workbook is opened? Many thanks

I need help resizing multiple pictures to their respective cells to which they have already been inserted into, here's the catch, If possible I'd like to do it all at once. I've tried: <tbody> <code class="vb keyword" style="white-space: nowrap; padding: 0px !important; font-family...

Hello, I am using the following code to loop through my worksheets and find the text "Method of Quoting:" -- once the value is found, it resizes the row to 100 as I need. I would also like to resize the "Source of Data:" row and the "Description:" row. Is there an easy way to add these two...

I have the following formula which sums the first i rows and j columns of a range ("MyRange") using Resize: WorksheetFunction.Sum(MyRange.Resize(i, j)) Now is there an equivalent VBA function which can be used with a general VBA array (and not just a range)?

Hello, I am attempting to find a code that goes through all worksheets in activeworkbook and searches column C for the term "Method of Quoting:", when it is found, I would like to resize that row height to 100. Is this possible?

Anyone have experience using their ActiveX Controls in Excel? I've built a workbook using the standard ActiveX controls available from the developer tab directly in a sheet (Windows 7, Excel '13). I have issues with their behavior when viewed at a different resolution, or in Windows 10. Combo...

I need help modifying this code. When I use this code I need it to resize the picture to fit into the selected cell but keep the same aspect ratio. Also, is it possible to have the code compress the picture to reduce the file size? Sub piccy() Dim sFile As Variant, r As Range sFile =...

Hi :) I am using excel 2016 and I want my cells to fix automatically, for ex., if I enter the text into my cell and that text goes out of the cell size then the cell should automatically resize it. I want wrap text to be done automatically. can any one help? Now I am using the below code it...

Hi there, I would like to ask for help on how to resize based on the active cell location. I need the macro to copy the last 20 rows (Jan) of my existing data to generate the same formulas for the next Month. This is the code I recorded/edited. Range("A2").Select...

I am trying to create a template for labeling an electrical service panel It is taking a lot of tweaking, and I find myself having to resize the text boxes I am using for the breaker information. Is there a way to resize multiple text boxes at once. Using select objects I can select all my...

Sub CombineRows() Dim WorkRng As Range Dim Dic As Variant Dim arr As Variant On Error Resume Next xTitleId = "Ryan's Code" Set WorkRng = Application.Selection Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8) Set Dic = CreateObject("Scripting.Dictionary") arr =...

Hello, My first post, so please bear with me... I have a regular task where I receive a set of data in a fixed format and some of the data needs to be changed to alternate, default values. My solution involves the use of 2 tables, on separate worksheets, within a single workbook. I open the...

Hello, Is there and way to code so that the Excel Find/Replace window opens, is resized to be bigger, and the window stays there waiting for user import. Macros doesn't like it Thanks

Hi, I saw in JWalk's 2013PPw/VBA the following macro: Sub Macro5() ActiveCell.Resize(,6)=Array("Jan","Feb","Mar","Apr","May","Jun") End Sub I then wanted to reduce the following code in similar fashion: Sub AuthorizedShare() With ActiveWorkbook.Worksheets("Summary Quoted")...

Hi, I am trying to make a Macro to add trackers after clicking a button. My excel is set up this way: - The 1stColumn of Row 9 is a formula that shows today's date - Row 10 has 6 Column with 6 criteria - From Row 11 to Row 2010, they are formulas for the 6 criteria on Row 10 I am trying to...

Hi all, hope some one can help. Recently I have begun working with ListObjects, handy things definitely but they seem temperamental. In my current project i have a handful of them to store lists of data, my code seems to manage them well adding entries, removing entries etc but after around 6 or...

For Information Only I searched fruitlessly for help on working out how much text would fill a Caption on a Radio Button (or more precisely, would the intended text fit when populating the Radio Button via VBA). With the help of others Mr. Excel members, I offer the following VBA solution...

Hi, What I need is a macro attached to a button that will resize the table down to the last row containing data. The problem I'm having is that due to the sheet being protected users cannot resize the table via the bottom corner.The table also doesn't update as it uses formulas and references...

Hi Everyone, I have rownum and colnum set to a value -- these are row and column coordinates for the FIRST lookup value. However, when I resize the formula to do the next value (which would have coords [rownum +1, colnum], the formula is still doing the vlookup with the same lookup value...

Hi guys, I have a code which uses offset.resize to get a full range of cells but each time i try to define that range as an array - I keep getting the error 'Object doesn't support this property or method'. I made sure that the array has the correct dimensions, I was wondering if someone could...