First, I apologize if this is the wrong group, but it seemed "close".  NB
I'm calling this code from VBA in access, but you'll note there are no
access components (directly) involved, which leads me to believe it's more
likely an excel (or maybe VBA) "problem".

Running XP pro & Excel 2007
I was running this bit of code this morning to launch a shortcut on
the desktop, and everything was working fine.  While experimenting
with variations things went into "lala land", and now I can't get it

Novice
Excel 2003
My additions to a "ImportBigFile" macro by C. Pearson is working nicely
thanks to several here - thanks.  Found I have a wee bit of a problem though

I need some help woth code.
On cell B2 when focus is lost then compare its value with the value of A2,
if b2 value is less then A2 then I want to popup a message saying value in B2
cannot be less then A2 and bring the focus back on B2

Strange, I have written vb code which updates data when the file is opened.
But when I close the workbook the vb project is still showing in the vb
window.
So when I reopen up the workbook I now have two instances of the vb project

hi. i need to add values which are stored in cells with relative cell
references. for eg. ActiveCell.FormulaR1C1 = "=Sum(0.15*(RC[-3]-RC[-6])
+ H12" . Is this possible? and if it is, i would also like to know how
to change the reference to a row above or below. thanks in advance.

-----------------------------------------------------------------
Dim myExcel As Excel.Application
Set myExcel = CreateObject("Excel.Application")
myExcel.Workbooks.Open myPath, UpdateLinks:=False, ReadOnly:=True

---------------------------------------------------------------------------------
        Const mFormat_DollarAmount             As String = "#,##0.00"
4140    With .Columns(mColNum_FP_AmountOutstanding)
4141       .ColumnWidth = 15

I use start and end time data to fill staff resource.  I want to build
in some error capture where the end of the duty is less than the value
of the start of the duty.  However, on occasion we have staff starting
at 22:00 and finishing at 06:00.  This would result in an error

I have an add-in that on one user's PC is saying office library invalid or
contains invalid references when it is executed.  However, in Tools,
References, all is fine.  None are missing.  All references are the same as
another add-in which works fine.  I've rebuild the add-in ...

Excel XP & 2007
An OP has asked me if there is a way to control the position of a MsgBox on
the screen.  I know of no way to do that.  Is that possible?  Thanks for
your time.  Otto

Instead of using the code below, is there a way of setting the
colorindex of offset(0,0) to offset(,4)?
Err.Offset(0, 0).Interior.ColorIndex = 3
Err.Offset(0, 1).Interior.ColorIndex = 3

I posted this earlier on an old thread, but I guess it doesn't bump the old
thread for people to see.  I hope I'm not breaking any rules or whatever, so
please ignore this post if I am.
Thanks,

Hi all,  I have searched on this group and also many websites about
how to create Progress Bar. Few sites are below
http://www.erlandsendata.no/english/index.php?d=endownloaduserforms
http://j-walk.com/ss/excel/tips/tip34.htm

I am looping through multiple named ranges.  Depending which named
range a value is in, I need to reference another named range
(basically Monday, Tuesday etc).  How Can I Select Case to find the
named range of the current cell to determin which other named range to