I have a list of zip codes that I need attach zone numbers to.  I wish
it were as easy as saying all zip codes from 00001-20000 = zone 1,
20001-40000 = zone 2...but they're all over the place.
So, I'd need to do something like zone = 1 if (000-003) or (588-595) or

Is there a way to log the date time a macro was run?
For example, i have a button that fires off a macro, the user selects when
to hit the button, but the choice to hit it may be based on how much time has
elapsed since it was last hit. If i could put a date / time in an adjacent

How can I view worksheet or open workbook in the UserForm?

When I run the following macro:
--------------------------------------------------------------------------
For r = 2 To 50
For c = 4 To 50

This is Charlie again to bother you.
I remember last time you gave me solution for my excel query.
I hope you will help me to solve this as well.
Name    hit1    hit2    hit3   

I have a vb that takes details from excel and populates word.  I need t
know how to then save the word doc to a drive using a filename whic
will be a variable in the VB and close.  any ideas?
thank

The left side of menu bar is "File....."
How can I add text into right side of menu bar?

Terms change in my transaction after a specific IRR (internal rate of return)
is acheived.  I can test for what year that IRR is triggered.  How do I
calculated what is the amount in that year to help the step and use the next
tier of the waterfall?

Share work book in Excel. There are 5 tabs. 4 of the 5 tabs are handle by 4
person. 4 person enter their own workbook (They will enter the numbers). 1 of
5 tab is total the numbers from 4 tabs. I wrote a macro called savefile() and
trigger it under worksheet_change event. The ...

I need to know the mathematical equation for the PMT funtion in Excel aswell
as how it uses values i.e PMT(0,0,0) i need to know wot it does with the
values
Thx

Hey Guys
I need to read a Worpad format in Excel.
I depend on a wordpad app to input text to a SQL database. I then read the
text field from the DB via ADO into Excel using nvarchar for the text field

The following is my weekly reconciliation spreadsheet. I need help with a
macro to do the following.
A          B        C      D      E     F        G       H       I
Order#     B9       IH     Bal         Check     Qty     Kgs     $

excel
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I

Hi again!
I am using some methods to create a textfile with just one line. Like "
The process begun at monday 3 PM" or something like that. This line
will always be updated (actually the whole file).

I ran this code
Code:
--------------------
   Sub Macro2()