Giving back 2 155 (11/19/2009 10:46:02 AM)
Hi all, In the spirit of giving back, I want to share with the Excel Community some of the tools and utilities I have written. Currently, these are acceseed and stored in my personal.xlsb file. There i...
Utf

combo box value 3 177 (11/21/2009 2:43:01 AM)
Where can I put the "value" direct in the properties setting instead of putting a range name? How should I input the value in "ListFillRange"? ...
Utf

Chart Question for Excel 2003 **Desperate** 1 135 (11/20/2009 1:27:45 AM)
I'm using Excel 2003 In the assignment for the students we have two charts (clustered column and a pie chart) based on values on the Statistics tab. The file is Contest.xls I'm working on a macro that will ...
Mr

Only keep rows that contain 7 422 (11/19/2009 9:42:09 PM)
I posted this question once, but didn't phrase it properly; let me try again. I want to delete all rows that do not contain the text of T75TA in column A. There are over 10,000 rows of data so this macro...
Utf

simple question regarding pasting 2 206 (11/21/2009 12:17:38 AM)
I have two columns. BA and BP BA has data in every row all the way down BP has data in most of the cells, but some are blank utilizing a formula of =IF(ISBLANK(BN7),"",BA7 & "," & BN7) Column BP is merel...
srosetti

Set Print Area with Dynamic Start Point 2 405 (11/20/2009 9:26:01 PM)
I want to test a row for a date, for the start cell, for the print area. Using that cell as a start, select 11 more columns, and 44 rows to set the print area. Sub Test1 () Range("G17").Select Do...
Utf

Workbook_Activate() vs Workbook_Open() 1 179 (11/21/2009 12:41:23 AM)
So, when a user opens my Excel file, my Visual Basic script is going to automatically fill the cells on the current sheet with predetermined values.... My question is, does it make a difference if I place ...
Robert

Want Macro to save to .xlsx 2 758 (11/20/2009 1:56:01 AM)
I hope someone will help me with the code below, please. I want to save the workbook to an .xlsx format so that the user can run the code from the macro in the template workbook but save the results to a wo...
Utf

Selection Change Event 8 164 (11/20/2009 4:03:23 PM)
I have added an Selection Change Event in my workbook. However, problem is found when I perform copy and paste. The data is "lost" (the "Paste" is in light grey) after I has right clicked another cell. A...
pwz

Error 13 Type Mismatch 4 136 (11/19/2009 7:08:12 PM)
This code is to hide the entire row if the cell in column D is empty. This code returns the Type MisMatch error: Sub hideme() Application.ScreenUpdating = False Dim myrange As Range, myrange1 As Range ...
Utf