Hello all, I am trying to insert a comment if the content of a cell is
changed in a protected sheet. I have turned off "Move selection after
enter" on the Edit tab and i have put this in my code
"Application.MoveAfterReturn = False". But after enter it still jumps to

I would like to know how I would build a macro that deletes an entire row
that has a zero in column A.  For example, my column A has values greater
than 0 until the end of the report and then the values are all be zeros:
16

I'm using Excel 2003.  When I open a worksheet, I would like the cursor to
move to a cell to the right of a cell with the current date in it.  Is there
an easy way to do this?

I need help on how to get the URL path for an active file that is stored in
an eRoom.  I'm trying to generate a link to the file to include in an email.  
When I use the Visual Basic command ActiveWorkbook.Path I get
C:\...\ApplicationData\eRoom\eRoomClient...

I am trying to export a chart using the Excel11 object from C#.  I can
properly open workbooks and read cells, but calling Export() on the Chart
object throws a COMException
Exception: System.Runtime.InteropServices.COMException (0x800A03EC):

Hello,
I posted earlier about what were Calls to Windows API, and I feel like I
should have known or at least come across that before, so I'm just wondering
if there are any other "Funky", things that are out there but may often be

I wish to copy only rows where there is an entry in column A. For those
rows, I wish to copy the entire row (values only) to another sheet.
tia
James

how to substract two hexadecimal numbers

Hi, in the following link: http://j-walk.com/ss/excel/tips/tip23.htm
it is well explained how to activate the undo comand if a VBA code is run,
my rpbolem is that I have a userform and when I activate my userform and my
userform change the data on the range I can not undo the ...

I hardcode the password to protect the workbook and all its worksheets
within the auto open macro, however, is there a way to auto expire, disable
usaged and prompt to change this password every month say after the 15th with
VBA only?

i have referred to couple of posts that were there before, but could
not get what i really wanted.
I have a shared worksheet where number of people updates a data
simultaneously.

I've got the following 4 formulas in an excel wroksheet:
=SUM(E7/Sheet1!$B$3)*52    E7 = Feb   $B$3 = 4
=SUM(D7+E7)/Sheet1!$C$3*52   D7+E7 = Jan + Feb    $C$3 = 8
=SUM(D7+E7+F7)/Sheet1!$D$3*52     D7+E7+F7 = Jan+Feb+Mar  $D$3 = 13

I'm trying to create a quick/short code approach for defining a group of
previously declared (as long) variables. These variables identify the correct
column for various types of data based on single cell named ranges in the
header row and are defined for use later in a macro.

I know PI can be used in a formula in for a cell.  I am writing a macro to
provide the same formula while process other data.
When I try to use it, I get a compile error, sub or function not defined.
It is a complicated formula but (Cos(D1031 * Pi() / 180)......

I have a combo box in an Excel Form and have the following values added to
it( code below).I have two issues over here.
a.When i select a value say "wife" from the combo box all the values get
repeated in the combo box .