What is the code to clear the content of an entire column, except for the
cells that have formulas?
Thank you!

=COUNTIF(VLOOKUP(B2, SET,4,TRUE),1)
I am trying to use the above formula but it keeps coming back telling me
there is an error with it. Bascially I want to count how many rows in "SET"
are equal to 1 when a Column in "SET" is equal to the number in B2.

I have a macro where the infomation is being coppied from excel and
putting it in a word document. I can setup the font type and size
etc... no problems. What i would like to do is setup a header and a
footer in my excel macro and if i can set the pageup as well. Can

On an MS site, it referred to a document called "Writing a user-defined
worksheet function".  I am a long-time Excel user, but don't have VB
experience.  I want to create my own finctions that will calculate various
chemical parameters from user input arguements.  Can anyone ...

I know that in Access, I can cause things to happen when a field has been
changed.  I want to do something similar in Excel.  If any cell in a given
column (G) changes, I want a macro to run that will force the user to enter
data in another cell.

I want to use someting like the left command to identify the number to the
left of the first "/".
My intent is to identify the month entered in a cell (first digit or two to
the left of the first "/") so that I can then use if then statements to

I have a sheet where I use =Today() to fill in the date field when the
sheet is created.  When the sheet is saved then reopened at some
future time the date field gets changed to the current date.  How do I
automatically fill in the date cell when the sheet is first created

I'm new to VBA (Although I do have programming experience in other
languages).. I'm getting my feet wet, and trying to make a DB query to
a Firebird DB.
So far I have:

Hi, I have a report with 4 lines of title which are centered & span over 12
columns.  The first line contains a report number and rundate; separated only
by a single space.  I would like to have the report number on the far left
(left justify) and the rundate on the far right ...

Here's an example I found on the web
---
Find the last used Row on a Worksheet:
Sub FindLastRow()

Hey there guys,
I have a problem i would like some help with,
I have Two Sheets:
The first sheet i have is Called "Real Time"

I'm having a problem I can't solve.
Please do the following:
In a new worksheet
Fill Column A with any value down to row 36

Does anyone know a way to always keep calculation mode in automatic.  It
seems as I am working in different spreadsheets, they will change themselves
to manual calculation mode.  Sometimes I do not notice that the values did
not update when I made a change.

I have the code below to rename Worksheet 2.  When the value in 4, 6 is a
number, e.g. 5, I get an error.  Text works fine.  Any suggestions?
Thanks
Private Sub CommandButton1_Click()

I'm trying to create a template for users to enter data and have it input
onto a spreadsheet, there are some conditions i need to set using data
validation and im not sure how to do it.. There cannot be any
spaces,-,&,%,#... etc.. in the fields, but Numeric and Alpha are ok. ...