widths

  1. X

    Formatting

    Hello I wnat to be able to copy and paste from one spreadsheet to another without changing column widths. For example. Spreadsheet 1 is set up with the widths of the colums i need. The other excel Spreadsheet2 I need to copy out the data from this into spreadsheet1 but im colums go back to...
  2. M

    Looking for a vba solution for Column width formatting

    I have the first 8 columns in my sheet (A-H) set to desired widths. Does anyone know of any easy way to assign subsequent blocks of 8 (I-P), then Q-X), etc. to widths matching the first 8? In other words, A, I, & Q... would all be 17.57. B, J, R would all be 9.43... Many thanks in...
  3. peterbel

    Maintaining pivot table column widths

    Is there a way using VB to make sure that when pivot tables are refreshed their column widths are NOT changed? I have about 10 pivot tables on a spreadsheet tab, all derived from a master table on another tab. When I add new data to the master I refresh the derived tables using VB behind a...
  4. B

    Listbox column widths and count with VBA - why aint this working?

    Hey Im trying to get these two rows to work. Me.ListSelector.ColumnCount = 4 Me.ListSelector.ColumnWidths = "0 cm;2 cm;3 cm;3 cm" I got a listbox called ListSelector. I want to define with VBA the column count and the column widths. Cant find anything making this code wrong....
  5. D

    Button positions not quite right

    Hello Everyone, I have a multiple sheet workbook and I am trying to have a series of identical buttons, rectangles, and text boxes on each sheet in exactly the same position. I start by arranging sheet 1 as I want it and then I use vba to 'take a picture' of the positions, (nameLoc is a range...
  6. L

    VBA Shapes Unaligning More And More

    I have a bit of code that will loop and add shapes to pre-formatted sheet, all row widths are the same, all column widths are the same.. as the macro loops more and more the shapes start to become out of place but ONLY down, they don't move left or right, just further down than what they should...
  7. E

    VBA to re-position shapes

    Hi all, can any VBA whizzes help me out? I'm trying to programmatically maintain the position of autoshapes on my worksheet, one of the routines re-sizes column widths but I want to write into it something which remembers their position at the start of the routine and puts them back after the...
  8. D

    Multiple non contiguous Column Width Array

    Hi, I am trying to do an array of column widths where specific columns are selected and for each column there is a different width but with no luck, is it actually possible to do this in an array?. Example Column B - width 10 Column D - width 19 Column G - width 16
  9. B

    How do you modify the widths of the bars in a histogram that has unequal intervals

    I have created a histogram for data that is collected in unequal intervals (grouped data). I determined the frequencies and used the bar chart. I want to change the widths of some of the bars to different widths. I can find the following -- I click on one of the bars and it shows a width on the...
  10. 03856me

    Display column width with click and hold of left mouse?

    All of us in the office use Excel 2007, but when some of us hover and hold our left mouse down between the columns or rows we can see the actual measurement displayed. Does anyone know how to turn this feature on? I have have gone through all the "Excel Options" and can't figure it out...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top