Macro to change column width and active window zoom as columns are selected
Using Excel 2003, I want to be able to: 1. go from column to column and have the width change as specified. 2. Have the zoom increase as specified in cells c27 (normal % zoom) and c 28 (zoomed % zoom). 3. Limit these functions to rows > 14, so if the active row becomes <14, the zoom and the column width returns to... 21 Apr 2010 10:31
Consolidating Unequal Lists
Hello, I have 2 lists of data in different worksheets of the same workbook similar to below: Product City Apples London Oranges Birmingham Pears Manchester I want to create 1 list (2 columns) in 1 worksheet that looks like: Product... 22 Apr 2010 04:07
VBA Editor Menu
The VBA editor menubar is gone. I don't know what I did or how I did it but how do I get it back? ... 21 Apr 2010 10:31
How to find default property for particular object.
Hi, is there a way how to identify default property for given object. E.g., I know default property for range object is value. Where can I find the default property for other objects? Thanks Alojz ... 21 Apr 2010 18:48
Faxing from Excel?!
Hello, I have a guest membership application that I've created. It prints invitations and then employees can mail them to potential guests that have asked for an invitation. I've added the ability to create an invitation and then email it as an attachment. Now, the folks want to be able to send the invi... 21 Apr 2010 09:28
Match formula to match values in multiple columns
Hi all, does any friend know that how can I make below formula work MATCH(A2,$K$2:$M$30,0) ... 21 Apr 2010 09:28
Hi all, To me really strange, to some of you pretty common. Every morning when I turn my computer on, startup Excel and run the code below I get a an error message indicating that there's something happening or wrong with the commandline; .CreatePivotTable TableDestination:=ActiveSheet.Range("a1"), ... 21 Apr 2010 05:20
Warning off by deleting a sheet
Hi Is there away to set warning off when i deleting a sheet in Code ... 21 Apr 2010 05:20
how to change a figure into word formate in below the column of e.
... 21 Apr 2010 05:20
find by concatenation of cells
Dear experts, I would like to compare 2 large range of data and the criteria is a concatenation of 4 cells. Basically I need to know where (row) in range 2 I find the same concatenation as in range 1 to perform an operation. Ranges: for range 1: Cells (row i, from column 2 to 7) for range 2: Cells (row k, fr... 21 Apr 2010 05:20