autofit

Hi, I am working on a macro file which copies number of tables from the file to outlook email. Then it changes the alignment of all the tables to center. I was wondering if there is a way or code to autofit all this tables? Thanks in advance for your help. Really appreciate any help I can get...

Hi, I am relatively new to VBA and I have found a Macro which autofits merged cells to ensure they are all visible (by adjusting the row height). the only issue is, the VBA I have leaves a huge gap above the text that is autofitted. I can't seem to identify the issue. Any assistance, or any...

Hi Again VBA Experts, I am trying to select all sheets in my workbook after and inclusive of Sheets("ps"), then format each sheet. I have the following code. It selects all sheets, all sheets widen to 100, but only the first sheet (ps) is then reformatted to Autofit. Can you please point out...

I am using Excel 2010 and have created a new default workbook, Book.xlts, and saved it in the XLSTART folder. A Ctrl-N will create a new workbook in the open Excel window based on this default workbook, but it retains its original size. I would like this window to open as the standard...

Hey all, So the title of my post is slightly misleading...Some time ago I created two unique programs both serving the same purpose, to take data, organize it, then reproduce it on a PDF format. This has been working without any type of hiccup until this last week when both programs (that's...

Hi everyone, Apologies if this is somewhere buried in the forum, but I need to make some merged cells autofit. I found the code below, which works.. but the cells then become too high! The cells come out at about double the height of what I need them to be. Can you help? Thanks! Public Sub...

Hello, I am learning VBA and have a large code that formats an Excel spreadsheet. The code works, but I just want to see if there is a better way to write the code of Autofit and Autofilter than what I have below for the sake of learning. I ask, too, b/c I hear some people say to not use Select...

I have two sheets that have data entered. Sheet 2 gets text from a particular cell on sheet 1. When I enter data on sheet 1 the cell auto fits to show the text. This does not automatically happen on the corresponding cell on sheet 2. Is there a way to have the cells on sheet 2 automatically...

This is my first post here. I'm using a MAC with OSX El Capitan and Office 2011. I believe the newest update of Office or the new OSX upgrade made these changes to the Excel program. I've looked at all the possible preferences to remedy the problem but can't seem to find any solutions. 1 ) When...

Hi All, I would appreciate your help on a conundrum I cannot find an answer to. I assume this is actually so simple that I will be ashamed of having asked it afterwards :) I have two tables in MS Excel on different spreadsheets (I am currently using 365 version but this is true for each...

Hi, I am in deep need of your help guys. I need help with fixing a code that I got online to suit my needs. I would like it to paste pictures onto the excel file I made. I have two separate codes one for bring up the pictures using a specified path and one for auto fitting the file that i...

Hi! I have been looking and asking for solutions everywhere to find how to let the user autofit the columns when the figures are shown with ######## The best I could find was something like the code below but it doesn't work and on the other hand I want to make the macro work ONLY for the cells...

Hello, I have the below code that will copy a table in Excel and then paste it into Word. However I cannot get it to autofitcontents to the page: Sheet2.Range("F6:L" & (46 - Application.WorksheetFunction.CountBlank(Sheet2.Range("F6:F51"))) + 5).Copy...

I'm pretty sure that I have seen a workbook before, where the column widths adjusted themselves automatically whenever the value in a column got large enough that it required an adjustment to avoid seeing #######. And when I say automatically, I don't mean that the column was adjusted during...

I have a formula for an entire column that includes char(10) to insert a break, but Excel does not autofit the row when it become populated by the formula. Is there a setting I can change so that rows are automatically autofit? USING EXCEL 2010

I like to find out if a cell has a prefixed height or has the .AutoFit turned on. debug.print ActiveCell.AutoFit doesn't work!

Hi, I'm bored so I felt like making a pie chart of my cell phone data usage. I made a spreadsheet (table below) that has a column that labels each application and the corresponding data that it used. My macro then creates a second table of only the applications that used 2% or more of the total...

Hi, I have the following code in a macro that autofits a column's width... Columns("C:C").EntireColumn.AutoFit How can I adapt this so it autofits but won't reduce the column width below a value of 20..? Rgds, Chris

Is there a way to auto fit one cell. For instance ive got my column width for column "A" as 15.57 but i want cell "A12" to have a width of 32. I dont have any text in "B12" but i do in column C. but the text for column "C" has an alignment to the right with a width of 70. So i have plent of...

I have 22 identical worksheets for a financial report used by our businesses where Col A has categories, Cols B-J are used for numbers, and Col K is for comments. Col K is configured to Wrap text (also, for 'TEXT ALIGNMENT', 'Left (Indent)' and 'Bottom' are selected). To print the report...