I am trying to remove the maximize control (the small square control
common to most windows)  from the top right of Excel (the application,
not just the worksheet) and I can remove everything BUT the maximize
and minimize controls with code similar to:

Hello, for testing purposes, I would like to change the value of the Watch
variables that I have added to the Watch Window.  It appears that I can add,
delete or change the names, but the content itself cannot be altered.  Is
there a way to do it as part of the functionality of ...

I would like to shade cells in my spreadsheet based on information contained
within two date fields:
Column E = Target Date
Column F = Complete Date (left blank until task completed)

Private Sub CheckBox3_Click()
If CheckBox3 = True And Range("C2").Value = "1" And CheckBox2 = True
And Range("E2").Value = "Comments Cleared" Or Range("E2").Value = "No
Comments" Then

The basics of my application:
It takes a tab delimited .txt file created from exporting a report
from Quicken, and creates an Excel workbook, doing all kinds of
sorting, calculations, and formatting based upon user input.

I'm attempting to mine data from a web site, the problem is that the data I
wish to mine is displayed via java script, so normal web scraping routines
don't work.  What's a good method for scraping java info off of a web page?

When i use the Pl/sql developer function 'copy to excel', it creates/opens
an excel file for me in the "c.\...\temp" directory".
Now when I am in this file and I use the file/open and file/save commands
excel defaults to the  "c.\...\temp" directory".  

From time to time I have worksheets of data that have rows I want to
eliminate.  The rows I want to delete usually have something in common like,
all have a blank value in a specific column.  
In the past I have just modified a macro to specify which column I want to

I have to create a macro to get the max of a set range of 24 cells
repeating throughout the spread sheet.  i'm not familiar with the
syntax of vb for excel.  does anyone have any suggestions?

Can some one please help me with the below post,
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public
.excel.programming&mid=5bc775be-d632-41a3-8306-03c5d6cd9f90

I want to create a macro that opens the find box in excel and then I can type
in anything I want to find. I don't want to use the edit find to open this
box in excel. I have tried recording a macro to do this but when I rerun the
macro it doesn't open the find box or if it does ...

I have a cell that grabs the date of intake the next cell sees that cell and
puts in the last day of the month. for example if date of intake is 11/3/07
then the next cell shows 11/30/07. What I need is a formula to calculate the
number of days in the program.=DATEDIF(C16,D16 ...

We use a series of large workbooks to simulate business performance over
time.  These workbooks and VBA code have perfomed well, i.e. 2-4 seconds per
time iteration, using Excel 2003.  Running the system using Excel 2007 on a
new, high powered, dual core PC, using Vista takes 6-7 ...

Dear experts,
I need to perform a long loop with many actions on a numer of rows; these
actions  may result in incrementing the # of rows, and I had used a for -
next loop but it does not work, as the end value always stays the same as in

I am trying to gather data from web into excel. The problem is like
this.
1. http://incometaxindiaefiling.gov.in/knowtan/knowtan.jsp is address
of web site where you can search TAN data for the assesses using