If a cell returns a certain value, can a date be made to appear in an
adjacent cell that will not change even if the first cell's value does
change with time.  For example, if cell A1>=1, then B1 shows the date
A1=1, even though A1 will eventually excede the value of 1 (therefore

FIRST, thanks in advance to All that respond...
In this spreadsheet, I have text in B2:B30.  I would like to run a macro
once I edit one of the cells - the Macro is a randomizer formula, in which I
would like the result to land into F2:F30.  

I Have 3 columns with like 800 rows
column #1 is the year , column #2 is Codenumder , column #3 is the cost
year    code    cost
#1    #2    #3

I'm experiencing odd behavior with a spreadsheet in which I'm creating
a test plan for a software implementation.
In a section that tests results of activities for people in various
states (or groups of states), I'm imported the pertinent states as

what are the settings on a combobox to prevent the user editing entries
(the list of user names) that I've loaded using the "additem" method...if he
does edit his user name then it confuses the VLookup statement that the
combobox feed

I am using the following code
'   Create the argument
   arg = "'" & path & "[" & file & "]" & sheet & "'!" & _
     Range(ref).Range("A1").Address(, , xlR1C1)

I have 4 key ranges in a file.  I do not want the users to be able to change
the range names.  It seems if you do not Protect each sheet then they will
have access to the ranges in Insert / Name / Define.  The sheets are
protected but If they insert a new worksheet then they will ...

I would like to know how to insert a de-limited txt file at the next
available row in column B.

I import electrical measurement data into a sheet run some conversion
and formatting macros on it. Then, split the data up for analysis,
manually,  based on three of the columns titles DCODE, CONFIG and JOB
NUMBER.

My BEGIN row range is "B8,D8:E8" END row range is "B15,D15:E15". I need
to check each row value and if the row is all blank I want to exit sub,
if the row range has all data then I want go to continue macro, if a
row has a blank cell I want to continue macro.

I run something like:
Sub Macro2()
Dim ws As Worksheet
For Each ws In Worksheets

Hi Programmers,
I have 2 sheets in a wbook, one that lists student names, and the other
that has student schedules.
On the schedules sheet, there are 7 school hours and each is a

is there a way in Excel to force the file name and path - thus preventing
the user from choosing his own under the file, save as drop down.
I want to do this to prevent users on a shared workbook saving versions of
the file...I want it to always save to the same file on the ...

hi, could you guys tell me how to write a matlab code to read data in
an excel file on a remote sever? to access this server, you also need
to provide cookie...
thanks in advance~!

i am doing following formula in C1 but facing error !
Col_A           Col_B         Col_C
Amount        Ex.Rate       US$
SGD 100       10.00         USD 1,000  (=A1*B1) this type is okay