I have created a purchase order form automating many functions using
VBA in Excel97.  One problem I seem to be having is that when users
take a long time to file out the form they end up with a runtime error
caused be the loss of variables.  How can I ensure all variables remain

I have a problem that I cannot figure out.
How to subtract a fraction of time from a Start time:
A1=08:50 AM , A2 needs to test A1 for less than or greater than 7 minutes of
09:00 AM.  

Greetings all, I am developing a workbook for data collection in a
research project (which will be used from a PDA).  We are tracking plant
species that occur at a particular site and I have a picklist from which
the user can choose one plant among about 200 that could potentially

I am new to working with VBA and I need some help. I am trying to
create a commission structure based on sales ranges - here is what I
have got - not sure how to write if its less than one amount but
greater than another (or vice versa)

I am very new to writing macros and have come acrossed this problem
when I am trying to finish off my assignment. We are not allowed to use
UserForms, so I've selected to use inputboxes. My problem lies in
calling out the duration function from excel..whenever that line of

Hi I have this small query.
I have written the macro (my first!) as below
Function FindOldNominal(NomCode)
FindOldNominal = WorksheetFunction.VLookup(NomCode,

I need to import data (txt file) that changes often.  Each time it changes
the name changes based on the time stamp.  How can I import the most recent
filewith macro or VBA?

I am using a macro workbook to run commands to create a new workbook and
other stuff. In addition, I want to create VBA codes for a new command button
with codes to "print" all worksheets in this new workbook (not my macro
workbook). My macro workbook will be closed before users ...

Sometimes in using a For/Next Loop, I notice that there is just "Next"
and sometimes "Next and (whatever). Is there a difference? TIA
Greg

How can I manually open a workbook without the running macros that are set to
run when the workbook is opened?
Thanks in advance,
Raul

I have a list of trades that I keep track of.  The file just keeps
getting longer and longer.  At the end of the day I would like to click
a macro that looks at Sheet1 and checks to see if the date (in column B)
is today’s date.  If it is copy that line to Sheet2 and continue to

i want make COUNTIF formula with two Colums detail is as under.
1- ex:  =COUNTIF( A1:A10=CAR & B1:B10>=50)
2- ex:  =COUNTIF(A1:A10 >=10  & A1:A10 <=100)
Please help me.

I am trying to write code for the user to ensure that they have checked for
certain criteria before they protect the sheet. My code is as below. However,
if a criteria is not met then the user exits the sub routine, corrects the
criteria and presses the submit button again. ...

Is there a code which will allow me to click on a cmd button to add the
infromation shown in certain cells on the excel worksheet into an existing
Access Database to specific fields.
Thanks

How do I delete entire rows in a spreadsheet with a VBA macro?
I can't use autofilter (or similar techniques) as not all of the columns
have data in every non blank row i.e. if I sorted by column A, there may be a
row with a blank cell in column A, but another column (say AX) that ...