Giving back2155 (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 value3177 (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"?
Chart Question for Excel 2003 **Desperate**1135 (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 contain7422 (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 pasting2206 (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 Point2405 (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
Sub Test1 ()
Workbook_Activate() vs Workbook_Open()1179 (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
My question is, does it make a difference if I place ... Robert
Want Macro to save to .xlsx2758 (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 Event8164 (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 Mismatch4136 (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:
Application.ScreenUpdating = False
Dim myrange As Range, myrange1 As Range