wide

I would like a simple code to sort a Named Range called MyRange. 1 Column wide sorted Alphabetically No headers

Co-Worker of mine has the current problem, wondering if anyone knows a fix. "It opens as it should, but when I move them to another monitor it stretches. It’s stretching so wide I sometimes lose sight of the minimize/maximize buttons too." When she tries to move the report to another monitor...

A report that I'm building has a graphic in the top right corner. The user wants the final output to be printable to one page wide. I have the following code at the end of the report production 'adjust column widths ws.columns("A:S").EntireColumn.AutoFit With ws.PageSetup...

I am copying the format of one worksheet to another and setting the column widths the same. This line column_width = original_ws.Cells(width_row, column).Width returns 82 The cell is about an inch wide. This line sets the column about five inches wide new_ws.Columns(column).ColumnWidth =...

I'm trying to hide or turn off horizontal scroll bars in a listbox. It's a single column listbox holding one chrW(9660) and only needs to be about 20 wide. But the width must be 71 or more to not have a scroll bar. Any fix for this ? Thanks.

Imagine you have a very long roll of material, (Rolled up like a big spool) and out of that material, you cut sections of material out of it. For an example, we're dealing with a 72" wide piece that's 1000' Feet long. If you were to never cut anything from it, and look at it as if it was...

So.. I'm trying to create something in excel that can help us keep track of cutting fabric. Let's say I started out with a 500' X 72" roll of fabric. and then let's say I start to make cuts on it. So let's say I cut off 130' by 40" wide. It would leave me with 370' X 72" and then a remainder...

I've been handed a data set with 70,000 entries - that were put together by someone lacking vision and understanding. They put in Column A the employees' entire name - in varying forms - and we need to extract it all. in to new cells for first, middle initial/name, last, suffix. Below is...

I know how to increase the fonts on screen, I know how to go into page set up and say fit to certain page size wide and certain page size high, but what I'm having a problem with is getting the printed text to alter, so that when it is printed I can actually read it. It seems to be large on...