Dear All
i want to wirte macro for attach NAV calculation. i want when i click on
button
the macro will calculate the results,steps are mention in sheet, please find
the attach sheet.
--~--~-~--~~~---~--~~
You may use the following code instead of last one. In place of msgbox you
can call some macro which you wish to run when Enter is pressed. The
present code assumes column 3 as having the data instead of column 4 which
you need.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim
Hi,
I want to basically fetch historical data of stock markets -
derivatives - from the website of NSEINDIA.COM, when i manually go to
the site and try to fetch data for a data, the URL generally comes
like
eg:
http://www.nseindia.com/content/historical/DERIVATIVES/2009/MAY/fo06MAY2009bhav.csv
Hi Sabby,
Sorry for the delay in responce. Could you please attach a sample sheet so
that it is easy to understand the organization of the data in your
worksheets.
Regards,
Andy
On Fri, May 8, 2009 at 4:38 PM, Sabbycat dancoo...@googlemail.com wrote:
hi Aindril
as i am trying to calculate
Addressing the group
On Sat, May 9, 2009 at 11:35 PM, shariq khan shariqcoo...@gmail.com wrote:
Hi Harmeet,
Actually I got your ID from macro group and saw some of your macro codes,
they was really very good.
I need your help ,
I want 2 merge the 100 excel files placed in a folder
Can anyone explain a bit principle and ways of BREAKING passwords?
On Wed, May 6, 2009 at 7:28 PM, Kamal Gulati kamalgula...@gmail.com wrote:
Plz help me to crack the password for MS - Word.
Thanks and regards,
Kamal Gulati
On Mon, May 4, 2009 at 10:27 PM, Praveen Khunte
Hi,
I wrote this formula for ur purpose.
=IF(RANK($A2,$A2:$D2,1)=F$1,$A$1,IF(RANK($B2,$A2:$D2,1)=F$1,$B$1,IF(RANK($C2,$A2:$D2,1)=F$1,$C$1,$D$1)))
See the attached sheet for reference.
Let me know if this helps.
On Sat, May 9, 2009 at 8:53 PM, subs subbu1...@gmail.com wrote:
ca1 ca2 ca3
Dear Hari,
Plz send the advance book of excel along with the VBA and MACROS using
excel.
regards,
Kamal Gulati
E-mail:kamalgula...@gmail.com
On Sat, May 9, 2009 at 9:57 AM, hari kumar prekkeh...@gmail.com wrote:
Hi Prateek,
FYI.
This book covers basics. if need more details or