widths

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...

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...

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...

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....

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...

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...

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...

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

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...

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...