date:20110703

$$Excel-Macros$$ Re: required open xl addin

2011-07-03 Thread OpenExcel.com

http://openexcel.googlecode.com/files/OPEN_XL.zip

Best Regards
Ashish Jain
http://www.eXceLitems.com
http://www.OpenExceL.com

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

2011-07-03 Thread Rajan_Verma

See if it help

http://www.mrexcel.com/tip069.shtml

 

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of karunanithi ramaswamy
Sent: Saturday, July 02, 2011 9:29 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Urgent Help required!!

 


Sir,
  Do u have any idea of auto filling magic squre for a particular sum total.
Iam interested
to know it. Thanks if u could help.
   -R.Karunanithi

--- On Sat, 7/2/11, Rajan_Verma  wrote:


From: Rajan_Verma 
Subject: RE: $$Excel-Macros$$ Urgent Help required!!
To: excel-macros@googlegroups.com
Date: Saturday, July 2, 2011, 8:25 PM

See if it helps

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anshul Gupta
Sent: Saturday, July 02, 2011 7:39 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help required!!

 

Hi All.
 
As m working in a import house for that i have to sales bills on daily basis
i just want a help that makes me easy to make that
 
If someone tell that how to make 5 random numbers selection between 197.001
to 203.999 which gives the total of 1000.000
 
Please help meurgent guys 
 
Cheers 

-- 

--
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
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 

--
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
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 

--
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
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Extracting data from SQL server to Excel using macro

2011-07-03 Thread Rajan_Verma

Hi,

You can retrieve the From SQL Server by Creating a connection in Excel with
SQLServer..

 

Data -> Get External Data -> From Other Source ->  From SQL Server 

 

Give the Server Name  and all details , Excel will Create a connection
automatically with Server and take all the Data from Selected Table,

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Markkim
Sent: Saturday, July 02, 2011 9:09 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Extracting data from SQL server to Excel using
macro

 

Hi 

 

I know a bit of SQL..   can write a bit of complicated query..  

 

At work, I don't have Write right to SQL server..  because my role is to
investigate and report.

 

I would create a stored procedure and simply bring records I want using
'From other source' in Data tab. 

 

But that's not possible. 

 

What I want is 

 

for Macro to connect to the SQL Server, then feed a query into SQL server..
and bring the result to Excel. 

 

Is it possible? 

 

Is there a book about it, which has some good explaining with a good
examples??   (I have been searching online for hours now) 

 

or do I have to use .net?? (I just know very little bit about it) 

 

any advice will be appreciated. 

 

Ultimately, I'd like to manipulate data from SQL server further in Excel
using Macro. 

 

My target is to make the whole process automatic. 

 

Cheers

 

 

 

-- 

--
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
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

2011-07-03 Thread STDEV(i)

you are talking about *Permutation*

given number : 1 2 3 4 5
total arrangement of permutation  *=FACT(5)* =  *120*

==
12345 21345 31245 41235 51234
12354 21354 31254 41253 51243
12435 21435 31425 41325 51324
12453 21453 31452 41352 51342
12534 21534 31524 41523 51423
12543 21543 31542 41532 51432
13245 23145 32145 42135 52134
13254 23154 32154 42153 52143
13425 23415 32415 42315 52314
13452 23451 32451 42351 52341
13524 23514 32514 42513 52413
13542 23541 32541 42531 52431
14235 24135 34125 43125 53124
14253 24153 34152 43152 53142
14325 24315 34215 43215 53214
14352 24351 34251 43251 53241
14523 24513 34512 43512 53412
14532 24531 34521 43521 53421
15234 25134 35124 45123 54123
15243 25143 35142 45132 54132
15324 25314 35214 45213 54213
15342 25341 35241 45231 54231
15423 25413 35412 45312 54312
15432 25431 35421 45321 54321
==


' VBA CODE:
'-
Dim D() As String  ' =Array Data Characters
Dim N   As Byte' =number of char
Dim Tulis   As Range   ' =range where output data to be written
Dim oRowAs Long' =Row index for Output
Dim oColAs Byte' =COlumn index for Output
Dim MaxRow  As Long' =oRow when reaching Fact(N-1)


Sub PermutArranger_Jilid3()
   '--
   ' this procedure is only preparing variables & inisials, and
   ' calling "ArrangeAndWrite" (main procedur) for the first time
   '--
   Dim k As Byte

   oRow = 0: oCol = 1
   N = Len(Trim(Range("B2")))
   Set Tulis = Range("L5")
   ReDim D(1 To N) As String
   MaxRow = WorksheetFunction.Fact(N - 1)
   ActiveSheet.Unprotect xpas
   ClearDataArea ActiveSheet.Range("L2")

   If N > 9 Then
  MsgBox "max 9 digit, due to limitation on number of cells in a
sheet..", _
 16, ThisWorkbook.Name
  Exit Sub
   End If

   For k = 1 To N:  D(k) = Mid(Trim(Range("B2")), k, 1):  Next k

   Application.Calculation = xlCalculationManual

   Call ArrangeAndWrite(D, 1)
   Application.Calculation = xlCalculationAutomatic
   ActiveSheet.Protect xpas

End Sub



Private Sub ArrangeAndWrite(ByVal D, i As Byte)
   '  this is a recursive procedure
   '-
   Dim txt As String, tmp As String * 1, j As Byte
   *' limitation (if i = N)*
   If i = N Then
  For j = 1 To N: txt = txt & D(j): Next j
  If oRow = MaxRow Then
 oRow = 0: oCol = oCol + 1
  End If
  oRow = oRow + 1:  Tulis(oRow, oCol) = txt
   Else
  For j = i To N
 tmp = D(j): D(j) = D(i): D(i) = tmp
  ArrangeAndWrite D, (i + 1)
  Next j
   End If
End Sub
'---


you can download my example workbook, if you like, at:

http://www.box.net/shared/22pginzj8p

kind regards,
siti Vi



On Sat, Jul 2, 2011 at 10:47 PM, Markkim  wrote:

> Hi
> I can think of a way to write this macro.
> What I want is to find any possible combination of numbers from given
> numbers to a given total. For example,
>
> Let's say
> Given numbers: 1, 2, 3, 4, 5
> total = 30
>
> Will it be possible to get any combination of Given numbers adding up to
> 30?
> Macro should say number of possible combinations and details of
> combindation
> I have been thinking about this macro for long time...  but I can't think
> of any way..
>
> Any ideas???
> cheers!
>
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish Koul :)

2011-07-03 Thread ashish koul

Thank You All..

On Sat, Jul 2, 2011 at 10:37 AM, Brajesh Kumar Porwal <
brajeshkumarpor...@gmail.com> wrote:

> *Congratulations Ashish keep it uppp-- *
> ***
> *
> *-- *
> *--
> One Team One Dream One Goal
>
> Warm Regards,
> Brajesh Kumar Porwal
> E-Mail :- brajeshkumarpor...@gmail.com
> 7503020750,
> "We can't Spell S_ccess without U"
>
> Life is Very beautiful !!!
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
> `•.¸.•´.
> *
>
>
> On Sat, Jul 2, 2011 at 10:10 AM, Suriya  wrote:
>
>> Congrats Ashish Ji..
>>
>> You are really a MVP
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
>
>  --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Leave tracker help required

2011-07-03 Thread maulik desai

HI Vasant



Sorry for the late reply & thanks you very much for the effort,.



Like to tell you that everything is perfect except one change need to do is
that when ever Emp taken leaves continuously like say (15th June to
23rdJune ) so when I click for output it should give me only one entry
but as
per your sheet it gives me 6 entries)



In Short:

1)  Whenever Emp takes continues leaves (like Mon to Thu , Tue to wed ,
Mon to Fri ) I want only one entry And *(need to modify code for this)*



2)  whenever Emp absent or taken leave on fri & mon then From & to Date
will be from Fri to Mon *this is comes properly in output. (no need to
change the code)*





3)  And if Emp taken leaves or diff dates then from & to dates will be
same like (13th June to 13th June) *this is comes properly in output. (no
need to change the code)*



Rest is fine

Request you to kindly make the small change & resent the file



Thanks in advance

On Sun, Jun 26, 2011 at 11:32 PM, Vasant  wrote:

> Hi Maulik
>
> Pls find the file attached
>
> I have created 3 sheets, in line with your original file. The code reads
> the data from sheet1 and populates sheet2 and sheet3 as per your
> requirements
>
> i encourage you to go through the code and understand it, so that you will
> be able to make modifications as per your original file.
>
> Also i would suggest that you use drop down list in sheet1 in the input
> area in order to  avoid typo errors.  Refer Y5 in sheet1.
>
> Hope this helps ! :)
>
>
> 'Code used
>
> Sub GetTotals()
> Dim DataWkSht As Worksheet, Lrow As Integer, LCol As Integer
> Dim StartRow1 As Integer, StartRow2 As Integer
> Dim LvDtls As Worksheet
> Dim LvSummary As Worksheet
> Set LvDtls = ThisWorkbook.Worksheets("Sheet2")
> Set LvSummary = ThisWorkbook.Worksheets("Sheet3")
> Set DataWkSht = ThisWorkbook.Worksheets("Sheet1")
> Lrow = DataWkSht.Range("A65536").End(xlUp).Row
> LCol = DataWkSht.Range("IV2").End(xlToLeft).Column
> For cntr = 2 To Lrow
> LvDtls.Cells(cntr, 1) = DataWkSht.Cells(cntr, 1)
> LvDtls.Cells(cntr, 2) = DataWkSht.Cells(cntr, 2)
> LvDtls.Cells(cntr, 3) = DataWkSht.Cells(cntr, 3)
> For ColCntr = 4 To LCol
> If Trim(UCase(DataWkSht.Cells(cntr, ColCntr))) = "IL" Or
> Trim(UCase(DataWkSht.Cells(cntr, ColCntr))) = "NCNS" Then
> If Weekday(DataWkSht.Cells(1, ColCntr)) = 6 Then
> If Trim(UCase(DataWkSht.Cells(cntr, ColCntr + 3))) = "IL" Or
> Trim(UCase(DataWkSht.Cells(cntr, ColCntr + 3))) = "NCNS" Then
> LvDtls.Cells(cntr, 4) = LvDtls.Cells(cntr, 4) + 4
> LvDtls.Cells(cntr, LvDtls.Cells(cntr, 256).End(xlToLeft).Column +
> 1) = Format(DataWkSht.Cells(1, ColCntr), "dd-mmm-")
> LvDtls.Cells(cntr, LvDtls.Cells(cntr, 256).End(xlToLeft).Column +
> 1) = Format(DataWkSht.Cells(1, ColCntr + 1), "dd-mmm-")
> LvDtls.Cells(cntr, LvDtls.Cells(cntr, 256).End(xlToLeft).Column +
> 1) = Format(DataWkSht.Cells(1, ColCntr + 2), "dd-mmm-")
> LvDtls.Cells(cntr, LvDtls.Cells(cntr, 256).End(xlToLeft).Column +
> 1) = Format(DataWkSht.Cells(1, ColCntr + 3), "dd-mmm-")
>
> SumRow = LvSummary.Range("A65536").End(xlUp).Row + 1
> LvSummary.Cells(SumRow, 1) = DataWkSht.Cells(cntr, 1)
> LvSummary.Cells(SumRow, 2) = DataWkSht.Cells(cntr, 2)
> LvSummary.Cells(SumRow, 3) = DataWkSht.Cells(cntr, 3)
> LvSummary.Cells(SumRow, 4) = Format(DataWkSht.Cells(1, ColCntr),
> "dd-mmm-")
> LvSummary.Cells(SumRow, 5) = Format(DataWkSht.Cells(1, ColCntr +
> 3), "dd-mmm-")
> LvSummary.Cells(SumRow, 6) = 4
>
> ColCntr = ColCntr + 3
> Else
> LvDtls.Cells(cntr, 4) = LvDtls.Cells(cntr, 4) + 1
> LvDtls.Cells(cntr, LvDtls.Cells(cntr, 256).End(xlToLeft).Column +
> 1) = Format(DataWkSht.Cells(1, ColCntr), "dd-mmm-")
>
> SumRow = LvSummary.Range("A65536").End(xlUp).Row + 1
> LvSummary.Cells(SumRow, 1) = DataWkSht.Cells(cntr, 1)
> LvSummary.Cells(SumRow, 2) = DataWkSht.Cells(cntr, 2)
> LvSummary.Cells(SumRow, 3) = DataWkSht.Cells(cntr, 3)
> LvSummary.Cells(SumRow, 4) = Format(DataWkSht.Cells(1, ColCntr),
> "dd-mmm-")
> LvSummary.Cells(SumRow, 5) = Format(DataWkSht.Cells(1, ColCntr),
> "dd-mmm-")
> LvSummary.Cells(SumRow, 6) = 1
>
>
> End If
> Else
> LvDtls.Cells(cntr, 4) = LvDtls.Cells(cntr, 4) + 1
> LvDtls.Cells(cntr, LvDtls.Cells(cntr, 256).End(xlToLeft).Column + 1) =
> Format(DataWkSht.Cells(1, ColCntr), "dd-mmm-")
>
> SumRow = LvSummary.Range("A65536").End(xlUp).Row + 1
> LvSummary.Cells(SumRow, 1) = DataWkSht.Cells(cntr, 1)
> LvSummary.Cells(SumRow, 2) = DataWkSht.Cells(cntr, 2)
> LvSummary.Cells(SumRow, 3) = DataWkSht.Cells(cntr, 3)
> LvSummary.Cells(SumRow, 4) = Format(DataWkSht.Cells(1, ColCntr),
> "dd-mmm-")
> LvSummary.Cells(SumRow, 5) = Format(DataWkSht.Cells(1, ColCntr),
> "dd-mmm-")
> LvSummary.Cells(SumRow, 6) = 1
>
> End If
> End If
> Next ColCntr
> Next cntr
> End Su

$$Excel-Macros$$ Assistance required

2011-07-03 Thread vikas verma

Hi All,

I am good with excel 2007 now I want to learn VBA coding in order to create
automation tool. Please suggest some ideas.

Thanks & Regards,

Vikas Verma
Bank of America
delhi.ve...@gmail.com

337199

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Valuable Info

2011-07-03 Thread Suryaprasad

Hi,

Register on the below link (FETISE) and get a instant 500/-  rs off on any
purchase of the product ..its really good and once after registered please
refer to your friends and get paid and own your gifts.

http://www.fetise.com/men/register2.php?refcode=81TJ5KG0G3

Thank you
Surya

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Assistance required

2011-07-03 Thread ashish koul

try these video tutorials and websites

http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/

http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/

On Sun, Jul 3, 2011 at 3:39 PM, vikas verma  wrote:

>
> Hi All,
>
> I am good with excel 2007 now I want to learn VBA coding in order to create
> automation tool. Please suggest some ideas.
>
> Thanks & Regards,
>
> Vikas Verma
> Bank of America
> delhi.ve...@gmail.com
>
> 337199
>
>  --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ help

2011-07-03 Thread vijayajith VA

HI Sir,

I am unable to run the program...if i press f5 or run the program. it will
ask

"Create macro " please see the attached sheet.


thankyou

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


vrate.xlsm
Description: Binary data

$$Excel-Macros$$ How to use Event Change to Change Color of Row

2011-07-03 Thread Ahmed galal




Hi all,I need to know how to use Event Change to Change Color of Row according 
to changing in specified Column cells.for example:I have column "S" any cell in 
it take code A,B,C,D,R & W.I need when any cell change in the column "S" taken 
one of the previous 6 codes, then the Row of it change to specified colorA,B = 
Grey ColorC,D = Yellow colorR = Reed ColorW = Green Color

Best regards,

 

Ahmed
galal Mohamed

Procurement
Engineer



Head
Office : SQUARE Engineering Firm

Tel   :(202) 2402 8846

Fax  :(202) 2405 0476

Mobile :(010) 9 62 60 61

Website : http://www.square.com.eg

31 Lebanon St. Mohandsen,
Giza, Egypt

  

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ help

2011-07-03 Thread ashish koul

workbook is not having any macro it contains UDF user defined function.
write =vrate(b1) in d1 and then drag down the formula. it work like excel
formula


 if you press alt + f11  and press on module 1
you can see the code

Option Explicit
Function vRate(iResult As Integer) As Variant
Select Case iResult
Case Is < 90: vRate = 0
Case Is >= 90, Is < 94: vRate = 10
Case Is >= 94, Is < 98: vRate = 25
Case Is >= 98, Is < 100: vRate = 50
Case Is >= 100, Is < 105: vRate = 75
Case Is >= 105: vRate = 100
End Select
End Function

its a user defined function not a macro
to wite a macro you have to start with "Sub " then name of macro









On Sun, Jul 3, 2011 at 4:11 PM, vijayajith VA wrote:

> HI Sir,
>
> I am unable to run the program...if i press f5 or run the program. it will
> ask
>
> "Create macro " please see the attached sheet.
>
>
> thankyou
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to use Event Change to Change Color of Row

2011-07-03 Thread ashish koul

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Count = 1 And Target.Column = 19 Then
Range("a" & Target.Row).Interior.Color = RGB(192, 192, 192)
Range("b" & Target.Row).Interior.Color = RGB(192, 192, 192)

Range("d" & Target.Row).Interior.Color = vbYellow
Range("c" & Target.Row).Interior.Color = vbYellow

Range("r" & Target.Row).Interior.Color = RGB(255, 0, 0)
Range("w" & Target.Row).Interior.Color = vbGreen
End If



End Sub


On Sun, Jul 3, 2011 at 5:45 PM, Ahmed galal  wrote:

>
> Hi all,
> I need to know how to use Event Change to Change Color of Row according to
> changing in specified Column cells.
> for example:
> I have column "S" any cell in it take code A,B,C,D,R & W.
> I need when any cell change in the column "S" taken one of the previous 6
> codes, then the Row of it change to specified color
> A,B = Grey Color
> C,D = Yellow color
> R = Reed Color
> W = Green Color
>
>
> Best regards,
>
>
>
> *Ahmed galal Mohamed*
>
> Procurement Engineer
>
> Head Office : SQUARE Engineering Firm
> Tel   :(202) 2402 8846
> Fax  :(202) 2405 0476
> Mobile :(010) 9 62 60 61
> Website : http://www.square.com.eg
> 31 Lebanon St. Mohandsen, Giza, Egypt
>
>
>
>  --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel Pop-ups

2011-07-03 Thread ashish koul

pls declare "I as Long"  then try




On Sun, Jul 3, 2011 at 8:41 PM, Rajan_Verma wrote:

>  *Please fill up this format with Some Example data so that we can help *
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mahreen Ellahi
> *Sent:* Sunday, July 03, 2011 5:47 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Fwd: $$Excel-Macros$$ Excel Pop-ups
>
>  ** **
>
> Hiii
>
> Thanks to ST Devi, I have reached up to this level , but the code shows
> some error now. Can anybody plz help me out.
>
> Regards
>
> -- Forwarded message --
> From: *Mahreen Ellahi* 
> Date: Sat, Jun 18, 2011 at 10:25 PM
> Subject: $$Excel-Macros$$ Excel Pop-ups
> To: excel-macros@googlegroups.com
>
>
> Hii
>
> I have a some data with limits expiry on different dates. I want to have
> popup window to appear whenever the limit is about to expire like 15 to 30
> days earlier. Can anyone help me for VBA coding.
>
> Regards
> Mahreen
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> ** **
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ Assistance required

2011-07-03 Thread Rajan_Verma

 

 

www.akoul.blogspot.com

https://www.facebook.com/ExcelLover

https://www.facebook.com/pages/Excel-and-VBA-Codes-Macros/15180389897

https://www.facebook.com/microsoftexcel

https://www.facebook.com/l.php?u=http%3A%2F%2Fwww.excelitems.com%2F&h=014d2&;
ref=ts

http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-o
nline/

http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/

www.ozgrid.com

akoul.posterous.com

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashish koul
Sent: Sunday, July 03, 2011 8:25 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Assistance required

 

 

 

try these video tutorials and websites

 

http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-o
nline/

 

http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/

On Sun, Jul 3, 2011 at 3:39 PM, vikas verma  wrote:


Hi All,

 

I am good with excel 2007 now I want to learn VBA coding in order to create
automation tool. Please suggest some ideas. 

 

Thanks & Regards,

 

Vikas Verma

Bank of America

delhi.ve...@gmail.com

 

337199

 

-- 

--
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
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel




-- 

Regards

 

Ashish Koul

  akoul.blogspot.com
http://akoul.posterous.com/

  akoul.wordpress.com

My   Linkedin Profile

 

P Before printing, think about the environment.

 

 

-- 

--
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
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ help

2011-07-03 Thread Rajan_Verma

Function procedure can not be Run By F5 if they have any Arguments, they can
only return a value on worksheet and to variable.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: Sunday, July 03, 2011 4:12 PM
To: excel-macros@googlegroups.com
Cc: NOORAIN ANSARI
Subject: $$Excel-Macros$$ help

 

HI Sir,

 

I am unable to run the program...if i press f5 or run the program. it will
ask 

 

"Create macro " please see the attached sheet.

 

 

thankyou

-- 

--
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
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ How to use Event Change to Change Color of Row

2011-07-03 Thread Rajan_Verma

Please Read this Article

 

http://www.cpearson.com/excel/Events.aspx

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ahmed galal
Sent: Sunday, July 03, 2011 5:46 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to use Event Change to Change Color of Row

 


Hi all,

I need to know how to use Event Change to Change Color of Row according to
changing in specified Column cells.

for example:

I have column "S" any cell in it take code A,B,C,D,R & W.

I need when any cell change in the column "S" taken one of the previous 6
codes, then the Row of it change to specified color

A,B = Grey Color

C,D = Yellow color

R = Reed Color

W = Green Color


Best regards,

 

Ahmed galal Mohamed

Procurement Engineer

 
 

Head Office : SQUARE Engineering Firm
Tel   :(202) 2402 8846
Fax  :(202) 2405 0476
Mobile :(010) 9 62 60 61
Website : http://www.square.com.eg  
31 Lebanon St. Mohandsen, Giza, Egypt

 

 

-- 

--
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
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to use Event Change to Change Color of Row

2011-07-03 Thread Vasant

try using conditional formatting.

On Sun, Jul 3, 201r1 at 5:45 PM, Ahmed galal  wrote:

>
> Hi all,
> I need to know how to use Event Change to Change Color of Row according to
> changing in specified Column cells.
> for example:
> I have column "S" any cell in it take code A,B,C,D,R & W.
> I need when any cell change in the column "S" taken one of the previous 6
> codes, then the Row of it change to specified color
> A,B = Grey Color
> C,D = Yellow color
> R = Reed Color
> W = Green Color
>
>
> Best regards,
>
>
>
> *Ahmed galal Mohamed*
>
> Procurement Engineer
>
> Head Office : SQUARE Engineering Firm
> Tel   :(202) 2402 8846
> Fax  :(202) 2405 0476
> Mobile :(010) 9 62 60 61
> Website : http://www.square.com.eg
> 31 Lebanon St. Mohandsen, Giza, Egypt
>
>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards

Vasant

skype Id: vasantjob
vasant...@gmail.com

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Assistance required

2011-07-03 Thread Venkatesan c

Hi Vikas,

Look the Below Link

http://excelvbatutor.com/vba_tutorial.html


*Best Regards,*
*Venkat*
*
*
On Sun, Jul 3, 2011 at 3:39 PM, vikas verma  wrote:

>
> Hi All,
>
> I am good with excel 2007 now I want to learn VBA coding in order to create
> automation tool. Please suggest some ideas.
>
> Thanks & Regards,
>
> Vikas Verma
> Bank of America
> delhi.ve...@gmail.com
>
> 337199
>
>  --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ help

2011-07-03 Thread vijayajith VA

Thankyou very much sir

I got it...

On Sun, Jul 3, 2011 at 4:11 PM, vijayajith VA wrote:

> HI Sir,
>
> I am unable to run the program...if i press f5 or run the program. it will
> ask
>
> "Create macro " please see the attached sheet.
>
>
> thankyou
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Unsolved Queries

2011-07-03 Thread vijayajith VA

Hi, rajan

Please can you explain event procedure ...

 I have gone thr several sites but still i dont kn how to use event
procedures

Thankyou


On Sun, Jul 3, 2011 at 8:48 PM, Rajan_Verma wrote:

>  Dear All,
>
> If you have any Unsolved Queries From Long time On Group , Pleas Post it
> again.. We will try to Solve it at earliest
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: Custom Function

2011-07-03 Thread SRemains

By working this function using debug. print (immediate window) and
studying the use of arrays, I was able to obtain the UDF I was hoping
to create. It takes a series of trade results (stock/futures/
options/...blackjack), such as -100, 500, 1500, -600 etc, and returns
the optimal fixed fraction of the next bet or wager one should take to
mathematically maximize your returns (assuming reinvestment of net
gains and a positive expectation for the system being tested) going
forward. I realized that I need a bit of work on using arrays in VB.
Here's the competed function. It could be improved by using Intersect-
Target for the range so it won't err on non-continuous ranges, but I
haven't done that yet. Hope it helps.

Option Base 1

Public Function Optimal_F(rngTradeResults As Range) As Double
'/ Re-code to use Intersect / Target so any size, non-continuous
will work
If rngTradeResults Is Nothing Then
'/Debug.Print "TradeResults Is Empty"
Exit Function
End If

Dim Rng As Range
Dim ProductTWR(1 To 99) As Double
Dim arrTradeResults() As Double
Dim TWR As Long
Dim Count As Long
Dim TWRs() As Double
Dim OptimalF As Double

Count = 1

For FVariable = 0.01 To 0.99 Step 0.01

ReDim arrTradeResults(1 To rngTradeResults.Cells.Count)
TWR = 1

LargestLoss =
Application.WorksheetFunction.Min(rngTradeResults)

For Each Rng In rngTradeResults.Cells
If IsNumeric(Rng.Value) = True Then
arrTradeResults(TWR) = 1 + (FVariable * (-Rng.Value /
LargestLoss))

   '/Debug.Print arrTradeResults(TWR)
End If
If TWR <= rngTradeResults.Cells.Count Then
TWR = TWR + 1
Else
TWR = rngTradeResults.Cells.Count
End If
Next Rng

Dim N As Double
Dim Product As Double

Product = 1
For N = LBound(arrTradeResults) To UBound(arrTradeResults)
Product = Product * arrTradeResults(N)
Next
ProductTWR(Count) = Product

If Count > 1 Then
If ProductTWR(Count) < ProductTWR(Count - 1) Then
Optimal_F = FVariable - 0.01

Exit Function
 End If
 End If

Count = Count + 1
Next

'/Optimal_F = FVariable - 0.01

End Function



On Jun 30, 9:11 pm, SRemains  wrote:
> I'm attempting a function that has a loop within a loop, to iterate an
> optimal value. I'm not seeing why it's not calculating. It returns
> #value!
>
> On spreadsheet, the following cashflow
>
> 100
> -500
> 1500
> -600
>
> Option Explicit
> Option Base 1
>
> Public Function OptimalF(ByVal MyCells As Double) As Double
>
>     '/Iterates thru possible F values, bound .01 to .99 finding the
> highest TWR
>
>     Dim FVariable As Double
>     Dim LargestLoss As Long
>     Dim TWRs(99) As Double
>     Dim nRow As Integer
>     Dim TradeResult As Double
>     Dim Count As Integer
>     Dim RowCount As Integer
>     Dim TWR() As Double
>     Dim MyCells() As Long
>
>     LargestLoss = Application.WorksheetFunction.Min(MyCells)
>     RowCount = MyCells.Count
>
>     With MyCells
>         ReDim MyCells(RowCount) As Single
>         ReDim TWR(RowCount) As Double
>         Count = 1
>
>         For FVariable = 0.01 To 0.99 Step 0.01
>
>             For nRow = 1 To RowCount Step 1
>
>             .Cells(nRow, 1).Value = TradeResult
>             TWR(nRow) = 1 + (FVariable * (-TradeResult / LargestLoss))
>
>             Next nRow
>
>         TWRs(Count) = TWR(RowCount)
>
>             If TWRs(Count) < TWRs(Count - 1) Then
>                 OptimalF = FVariable
>                 Exit Function
>             End If
>
>         Count = Count + 1
>         Next FVariable
>
>     End With
>
>     OptimalF = FVariable

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Sumif across multiple worksheets

2011-07-03 Thread Haseeb Avarakkan

Hello Susan,

If you just have 3 sheets, Sheet1, Sheet2 & Sheet3. use this;

=SUMPRODUCT(SUMIF(INDIRECT("'Sheet"&{1,2,3}&"'!D:D"),"C 
Wagner",INDIRECT("'Sheet"&{1,2,3}&"'!E:E")))

Or,

Enter all sheet names in a range, say in J2:J3, then use this;

=SUMPRODUCT(SUMIF(INDIRECT("'"&$J$2:$J$4&"'!D:D"),"C 
Wagner",INDIRECT("'"&$J$2:$J$4&"'!E:E")))

HTH
Haseeb

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ workbook location on status bar

2011-07-03 Thread netuser501

Hi,

Is there a code or a build-in option to have the location path of a
workbook permanently showing on the Excel status bar?

Thanks

Pascal

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Attachments to Group

2011-07-03 Thread sswcharlie

Hi

I want to post a message with .xls file attached.  Where is the button
to add attachments to email ?

Thanks


Charlie

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Attachments to Group

2011-07-03 Thread ashish koul

mail your workbook to excel-macros@googlegroups.com  and add   file as
attachement

On Mon, Jul 4, 2011 at 2:56 AM, sswcharlie  wrote:

> Hi
>
> I want to post a message with .xls file attached.  Where is the button
> to add attachments to email ?
>
> Thanks
>
>
> Charlie
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ workbook location on status bar

2011-07-03 Thread STDEV(i)

'--Thisworkbook Module:--

Dim OldStaBar As String

Private Sub Workbook_Open()
   OldStaBar = Application.DisplayStatusBar
   Application.DisplayStatusBar = True
   Application.StatusBar = ThisWorkbook.FullName
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
   Application.DisplayStatusBar = False
   Application.DisplayStatusBar = OldStaBar
End Sub



On Mon, Jul 4, 2011 at 2:41 AM, netuser501  wrote:

> Hi,
> Is there a code or a build-in option to have the location path of a
> workbook permanently showing on the Excel status bar?
>
> Thanks
>  Pascal
>
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Unsolved Queries

2011-07-03 Thread NOORAIN ANSARI

  Event
Procedure

*Event*- An *Event* is an action initiated either by user action or by other
VBA code.

As noted above, events are generated by:

· *The Workbook *

· *The Worksheets *

· The Application (User form)

· Charts



*Event Procedure**:-* An *Event Procedure* is a Sub procedure that you
write, according to the specification of the event, that is called
automatically by Excel when an event occurs

ByVal = *By Value* will change a value inside a Sub

By Val is Copy of Variable and not alter in originally.

ByRef = *By Reference *will Change a value globally.

*ByRef *will point to the Original Variable and represent it

*ByRef(By Default):* If you pass an argument by reference when calling a
procedure the procedure access to the actual variable in memory. As a result
the variable's value can be changed by the procedure.
*ByVal:* If you pass an argument by value when calling a procedure the
variable's value can be changed with in the procedure only outside the
actual value of the variable is retained.

   Event
For example,

(1)-Worksheet_Change
Event

Worksheet object has an event named Change.

Private Sub Worksheet_Change (ByVal Target as Range)

Application.EnableEvents = False


Target.Value = Target.Value + 1

Application.EnableEvents = True

  End Sub

(2)- Worksheet_SelectionChange

Private Sub Worksheet_*SelectionChange* (ByVal Target As Range)

Sheet1.Range(“A1”).value=12

Sheet1.Range(“B1”).value=13

Sheet1.Range(“C1”).value= Sheet1.Range(“A1”).value+ Sheet1.Range(“B1”).value

End Sub

(3). Worksheet_Activate

Private Sub Worksheet_Activate()

Sheet1.ComboBox1.AddItem ("Noorain")

Sheet1.ComboBox1.AddItem ("Pravesh")

Sheet1.ComboBox1.AddItem ("Rajiv")

End Sub

(4) Worksheet_BeforeDoubleClick

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)

Target.Cells.Borders.Color = vbRed

End Sub

(5) Worksheet_BeforeRightClick

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)

Target.Cells.Offset(1, 0) = "Noorain"

End Sub

(6) Worksheet_Calculate()

 (6) Automatic Calculation

Private Sub Workbook_Activate()

Application.Calculation = xlCalculationAutomatic

End Sub


-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 


On Sun, Jul 3, 2011 at 9:43 PM, vijayajith VA wrote:

> Hi, rajan
>
> Please can you explain event procedure ...
>
>  I have gone thr several sites but still i dont kn how to use event
> procedures
>
> Thankyou
>
>
> On Sun, Jul 3, 2011 at 8:48 PM, Rajan_Verma wrote:
>
>>  Dear All,
>>
>> If you have any Unsolved Queries From Long time On Group , Pleas Post it
>> again.. We will try to Solve it at earliest
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ How to use Event Change to Change Color of Row

2011-07-03 Thread Ahmed galal



Thanks ashish for code it helped me a lotnow i developed the code to be:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 19 And Target.Count >= 1 Then
Select Case Target.ValueCase "A"Target.EntireRow.Interior.Color = RGB(192, 192, 
192)Case "C"Target.EntireRow.Interior.Color = RGB(255, 255, 0)Case 
"C"Target.EntireRow.Interior.Color = RGB(255, 255, 0)Case 
"C"Target.EntireRow.Interior.Color = RGB(255, 255, 0)Case 
"C"Target.EntireRow.Interior.Color = RGB(255, 255, 0)Case 
"C"Target.EntireRow.Interior.Color = RGB(255, 255, 0)End SelectEnd IfEnd Sub
everything is ok., but when i pull + for any cell to Repeat letter "A" for 
example to fill more than on cell & automatically color fill also, it's return 
an error to me, how can i avoid it??

Best regards,

 

Ahmed
galal Mohamed

Procurement
Engineer



Head
Office : SQUARE Engineering Firm

Tel   :(202) 2402 8846

Fax  :(202) 2405 0476

Mobile :(010) 9 62 60 61

Website : http://www.square.com.eg

31 Lebanon St. Mohandsen,
Giza, Egypt

 

Date: Sun, 3 Jul 2011 20:41:40 +0530
Subject: Re: $$Excel-Macros$$ How to use Event Change to Change Color of Row
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count = 1 And Target.Column = 19 ThenRange("a" & 
Target.Row).Interior.Color = RGB(192, 192, 192)
Range("b" & Target.Row).Interior.Color = RGB(192, 192, 192)
Range("d" & Target.Row).Interior.Color = vbYellowRange("c" & 
Target.Row).Interior.Color = vbYellow

Range("r" & Target.Row).Interior.Color = RGB(255, 0, 0)Range("w" & 
Target.Row).Interior.Color = vbGreenEnd If



End Sub

On Sun, Jul 3, 2011 at 5:45 PM, Ahmed galal  wrote:








Hi all,I need to know how to use Event Change to Change Color of Row according 
to changing in specified Column cells.for example:I have column "S" any cell in 
it take code A,B,C,D,R & W.
I need when any cell change in the column "S" taken one of the previous 6 
codes, then the Row of it change to specified colorA,B = Grey ColorC,D = Yellow 
colorR = Reed Color
W = Green Color

Best regards,

 

Ahmed
galal Mohamed

Procurement
Engineer



Head
Office : SQUARE Engineering Firm

Tel   :(202) 2402 8846

Fax  :(202) 2405 0476

Mobile :(010) 9 62 60 61

Website : http://www.square.com.eg

31 Lebanon St. Mohandsen,
Giza, Egypt

 
  




-- 

--

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

 

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel



-- 
Regards
 
Ashish Koul
akoul.blogspot.com
http://akoul.posterous.com/


akoul.wordpress.com
My Linkedin Profile
 

P Before printing, think about the environment.
 




-- 

--

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

 

<><><><><><><><><><><><><><><><><><><><><><>

Like our page on facebook , Just follow below link

http://www.facebook.com/discussexcel
  

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$ workbook location on status bar

2011-07-03 Thread Rajan_Verma

Paste it on Workbook code module

 

Private Sub Workbook_Open()

Application.StatusBar = ThisWorkbook.Path

End Sub

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkatesan c
Sent: Monday, July 04, 2011 7:37 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ workbook location on status bar

 

Hi Pascal,

 

Please Try the below way...

 

In 2007 Go to Excel options --->Customize>all commonds--->document
Location ---add in quick access toolbar

 

and see the below..

 

 

-- 

Best Regards,

Venkat

 

 

On Mon, Jul 4, 2011 at 1:11 AM, netuser501  wrote:

Hi,

Is there a code or a build-in option to have the location path of a
workbook permanently showing on the Excel status bar?

Thanks

Pascal

--

--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel





 

 

 

 

-- 

--
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
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Excel VBA for BOM

2011-07-03 Thread Rash

Hi, 
FYI,
Sorry, the previously attached file already contains the macro, but its not 
full proof. It is not highlighting rows 137 to 142. because its not in 
sorted order.

Rash

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: required open xl addin

2011-07-03 Thread ankur

thnks
Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~



On Sun, Jul 3, 2011 at 12:33 PM, OpenExcel.com <26may.1...@gmail.com> wrote:
> http://openexcel.googlecode.com/files/OPEN_XL.zip
>
> Best Regards
> Ashish Jain
> http://www.eXceLitems.com
> http://www.OpenExceL.com
>
> --
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ need required for data validation value query

2011-07-03 Thread ankur

thnks rajan this is what i needed
this is really very nice of youit ease my work load...

now one more queryin attached file...sheet "gents report"cell
C2 value should get pasted in sheet "gents"...in the front of row
having staff no..
 example is shown..if income tax calculation show "error"...ignore
that data for pasting ..

Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~



On Sat, Jul 2, 2011 at 5:40 PM, Rajan_Verma  wrote:
> See if it helps
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of ankur
> Sent: Friday, July 01, 2011 5:17 PM
> To: excel-macros
> Subject: Re: $$Excel-Macros$$ need required for data validation value query
>
> sorry , i forget to attach a sample file in my query..
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
>
> On Fri, Jul 1, 2011 at 5:14 PM, ankur  wrote:
>> hi ayush/ all members
>>
>>  i have one data validation list, which is required in formula to get
>> a result i want the all results  corresponding to each value in
>> different sheet or in different column in one click any macro code is
>> there ?
>>
>> thanks in advance
>>
>> Have A Nice Time & Enjoy Life
>>
>> Regards:
>> CMA Ankur Pandey
>> (Someone Different)
>>
>> I'm not the best but i'm not like the rest~~
>>
>> --
>> --
>> 
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
> 
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Re: required open xl addin

RE: $$Excel-Macros$$ Urgent Help required!!!!!!!!!!

RE: $$Excel-Macros$$ Extracting data from SQL server to Excel using macro

Re: $$Excel-Macros$$ Macro for find any possible combination of numbers from given numbers to a given total

Re: $$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish Koul :)

Re: $$Excel-Macros$$ Leave tracker help required

$$Excel-Macros$$ Assistance required

$$Excel-Macros$$ Valuable Info

Re: $$Excel-Macros$$ Assistance required

$$Excel-Macros$$ help

$$Excel-Macros$$ How to use Event Change to Change Color of Row

Re: $$Excel-Macros$$ help

Re: $$Excel-Macros$$ How to use Event Change to Change Color of Row

Re: $$Excel-Macros$$ Excel Pop-ups

RE: $$Excel-Macros$$ Assistance required

RE: $$Excel-Macros$$ help

RE: $$Excel-Macros$$ How to use Event Change to Change Color of Row

Re: $$Excel-Macros$$ How to use Event Change to Change Color of Row

Re: $$Excel-Macros$$ Assistance required

Re: $$Excel-Macros$$ help

Re: $$Excel-Macros$$ Unsolved Queries

$$Excel-Macros$$ Re: Custom Function

Re: $$Excel-Macros$$ Sumif across multiple worksheets

$$Excel-Macros$$ workbook location on status bar

$$Excel-Macros$$ Attachments to Group

Re: $$Excel-Macros$$ Attachments to Group

Re: $$Excel-Macros$$ workbook location on status bar

Re: $$Excel-Macros$$ Unsolved Queries

RE: $$Excel-Macros$$ How to use Event Change to Change Color of Row

RE: $$Excel-Macros$$ workbook location on status bar

Re: $$Excel-Macros$$ Excel VBA for BOM

Re: $$Excel-Macros$$ Re: required open xl addin

Re: $$Excel-Macros$$ need required for data validation value query

33 matches

Site Navigation

Mail list logo

Footer information