It could be because you're not following good group etiquette? #1) your title should describe your problem. Otherwise all of the "problem in macro", "help required", "urgent please help" questions all look the same. I get over 100 emails a day, if 20 of them say "Problem in Macro", I assume that it is an ongoing discussion and don't join in. You subject should be unique and describe the problem.
If your problem involves pivot tables, then people that know about Pivot Tables
will jump in.
If you problem is dealing with Dates, then experts on dates will be interested.
#2) You should describe what you've done and what the problem is in the text
of the email. Some people will not open attachments from people they don't know
unless it looks like they've done some of the work instead of asking the group
to do the work for them.
As for your macro.
It sounds like you want to make the formulas NOT run until you ask them to.
What I would do is set the calculation for the worksheet to Manual.
have your change event update the number to analyze.
then calculate the sheet.
(using Activesheet.Calculate)
Or.. write your calculations into the macro instead of using formulas.
That way, you would have more control over the sequence.
You could then even keep two "inventory" columns, a before-transaction and
after-transaction.
hope this helps.
Paul
________________________________
From: IMAD KAYED <imadka...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Mon, August 16, 2010 4:40:04 AM
Subject: REMINDER !! $$Excel-Macros$$ Problem in Macro
I don't know why no body is interested in my problem now more than one week and
still no body is replying at least till me what is the problem.
-------Original Message-------
From: IMAD KAYED
Date: 15/08/2010 11:00:20 AM
To: excel-macros@googlegroups.com
Subject: REMINDER !! $$Excel-Macros$$ Problem in Macro
-------Original Message-------
From: IMAD KAYED
Date: 04/08/2010 03:31:05 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Problem in Macro
HI,
I have attached the file and the problem is explained in the file it self.
Kindly help me solve this problem.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
<<SENDER_EMAILIMADKAYED>>
