Re: $$Excel-Macros$$ Passing Variable to another function

[hanumant shinde]

Hi Paul,
Sorry for late reply as i was out of town i couldnt check this out.
Thanks a lot paul for your detail explanation.and really sorry for creating 
confusion.

my que is "Can a variable be passed to a function without initializing it" and 
getting their values. i have explained in detail below.

1. that variable is declared as global variable but it has not initialised 
anywer.
2. the called function work on that global variable which is passed to the 
called fucntion and changes its value but that function jus return "true" or 
"False" nothing else. then how that variable is assigned some value.

please find the example below

dim workingday as some data type

"workingday" this is declared as global variable.

Sub calling ()
if not (calculateworkingday(workingday)) then

'here we are passing that variable to some function 

.
end sub

'calculateworkingday this is called function
public function calculateworkingday(abcd as some datatype) boolean

' in this code we use 'abcd' variable and not that actual global variable.
'using this 'abcd' variable we change the value of 'abcd' 
'this function jus return 'true' or 'false' then how that acual value is 
changed? is it bcoz that variable is global? i tried same kind of thing i.e. 
passing global variable without initialising it but i got error.

calculateworkingday = true

end function





From: Paul Schreiner 
To: excel-macros@googlegroups.com
Sent: Mon, 7 February, 2011 11:41:24 PM
Subject: Re: $$Excel-Macros$$ Passing Variable to another function


Your question is a bit confusing:
You want to know "if we can pass the variables without initializing them to any 
other function and get their values from that called function "
 
"Initializing" a variable is not the same as "Declaring" a variable.
 
Dim workingday as Integer
 
"Declares" the variable "WorkingDay" as type Integer.
 
Workingday = 0
 
"Initializes" the variable, or sets the "Initial Value" to 0.
When a variable is first Declared, it's value is usually "null".
-
If your question really is: "Can a variable be passed to a function without 
initializing it", then the answer depends on what the function does with the 
variable.
 
If the function uses a statement like:
 
If WorkingDay = 0 then
 
it may produce an error if WorkingDay is null, because the resulting statement 
is:
 
If  = 0 then

 
If your question is "if we can pass the variables without DECLARING them":
 
The answer here is based on the understanding of Variable Declarations.
First of all, using:
Option Explicit
 
will cause the compiler to require that ALL variables be declared before being 
used.
 
But if Option Explicit is NOT used:
 
Rule #1: to a compiler, ALL variables are "DECLARED".
The question is: when/where are they declared?
 
You can declare them Explicitly by using:
 
Dim NewVariable
 
but WHERE this statement is placed is important too!
 
If you have a macro/Sub called "Calling", and use:
 
Dim VarModLevel
Sub Calling()
Dim VarSubLevel
 
then the Variable VarSubLevel is available ONLY within the Subroutine.
While VarModLevel is available to all subs in the Module.
However, it would NOT be available to Userforms and when macros complete.
 
Now, OUTSIDE of a subroutine, you can use:
Global VarGlobal
or
Public VarPublic
 
These variables are available until Excel exits.
 
a second way to declare variables is when passing a value to a function:
 
Function Calling(LocalVar)
will Declare a new variable "LocalVar" that is only available within the 
function.
 
 
Now.. if you are NOT using Option Explicit, then variables can be used
WITHOUT first declaring them.
 
This means that when you use:
 
IntVar = 100
 
The variable IntVar is "automatically" declared as if you used:
 
Dim IntVar as Integer
 
However, more often, Excel chooses to declare the variable as type Variant
(Dim IntVar as Variant)
 
At the same time, if you use:
 
IntVar = "100", then it gets declared as a STRING variable as if you used:
 
Dim IntVar as String.
 
subsequent attempts to use is as a number:
 
IntVar = IntVar + 1
 
will produce an error.
 
---
So.. to answer your actual question:
 
"if we can pass the variables without initializing them to any other function 
and get their values from that called function"
 
The problem in your example is that your function:
 
CalculateWorkingDay(abcd as some datatype)
abcd is declared as a specifid data type.
 
That means that the variable passed TO the function:
"WorkingDay" in:
CalculateWorkingDay(WorkingDay)
 
must be the same data type.
 
To test this type of thing, try this:
Option Explicit
Global TestVar
Sub Testing()
TestVar = 1
MsgBox "Testing: TestVar = " & TestVar
Test2
MsgBox "Testing2: TestVar = " & TestVar
End Sub
Sub Test2()
Dim TestVar, stat
TestVar = 2
MsgBox "Test2: TestVar = " & TestVar
stat = TestFunction(TestVar)
MsgBox "Test2a: TestVar = " & Tes

$$Excel-Macros$$ Question for you Excel Masters out there...

[MikeMikeMike]

Greetings,

I have a question I am hoping to find the answer of here...

I have a spreadsheet that signifies that includes revenue which is
represented on my pivot charts as bars represented by a month (a good
example but I could come up with others of course).  Simple enough
right? Well what if I have another metric that I am wanting to track
that is a drastically different number (average product cost to
customer) that I want to have on the same chart with that number
formatted as currency looking all nice and professional.

How do I do it?

Anyone that helps gets 1,000 thank yous on top of the 1,000 I am
giving to all who read this far ;-)

1,000 Thank you's to you all!

-Michael

-- 
--
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$$ Shorting Problems

[Vikas Chouhan]

Hi Sudhir,

please find the attachment and check it,




On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar  wrote:

> Dear Frnd
>
> I have list which have many repeated names
> i want short it with formula
>
>
> thanx
>
> --
> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
> Sudhir Verma
> Asstt. Mngr. A/c's
> 9818479722
> *
> P think Before you print
> *
> *
> **
> Life is Very beautiful !!!
> *
> *
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
>  `•.¸.•´.
> *
> *
>  *
>  *Happy **Valentine** Day  *
>   \ ¦ /
>  (ò ó)
> _ ___o0o___(_)___o0o__
> ___¦_¦_¦_¦_¦
> ¦_¦_¦_¦_¦__
> ___¦_¦_¦_¦_¦
>
>  --
>
> --
> 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
>



-- 
One Team One Dream One Goal

Warm Regards,
*Vikas Chauhan*
E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
9911868518,
"We can't Spell S_*ccess *without U"

Life is Very beautiful !!!
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
`•.¸.•´.

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


Sorting Name.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Shorting Problems

[Umesh Dev]

Hi Sudhir,

Select the row A => Click on Data Tab => Click on Advanced => Select Unique
Records Only. That's it.

Regards
Umesh




On Wed, Feb 9, 2011 at 4:29 PM, sudhir kumar  wrote:

> Dear Frnd
>
> I have list which have many repeated names
> i want short it with formula
>
>
> thanx
>
> --
> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
> Sudhir Verma
> Asstt. Mngr. A/c's
> 9818479722
> *
> P think Before you print
> *
> *
> **
> Life is Very beautiful !!!
> *
> *
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
>  `•.¸.•´.
> *
> *
>  *
>  *Happy **Valentine** Day  *
>   \ ¦ /
>  (ò ó)
> _ ___o0o___(_)___o0o__
> ___¦_¦_¦_¦_¦
> ¦_¦_¦_¦_¦__
> ___¦_¦_¦_¦_¦
>
>  --
>
> --
> 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$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

[rcamarda]

Here it is (I used the new google groups )

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


mouse test.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

[rcamarda]

Im not using the right mouse.
If you suggest that I use the right mouse, I'd need to disable the
format popup if I am in my target cell. IE
If Target.Count = 1 and Target.Column = 34 and Target.Value > 0 And
(GetAsyncKeyState(vbKeyLButton) = 1 And &H8000) Then
' my logic
End If

On Feb 9, 9:25 am, ashish koul  wrote:
> r u using right button also
>
>
>
>
>
>
>
>
>
> On Wed, Feb 9, 2011 at 7:53 PM, ashish koul  wrote:
> > can you share your workbook
>
> > On Wed, Feb 9, 2011 at 6:57 PM, rcamarda wrote:
>
> >> Ashish,
> >> 1. Your code worked from your example.
> >> 2. in my other tests, I added added the "= 1" I had, and some of my
> >> test sheets worked.
> >> 3. It didnt work when i put it into my sheet where I needed it,
> >> GetAsyncKeyState(vbKeyLButton) = 1 And &H8000 but it didnt work
> >> 4. I opened a fresh excel, pasted your code and it worked.
> >> 5. My sheet has macro enabled, so I saved your test book as xlsm and
> >> your test still works.
> >> 6. I can create a new sheet in my excel, and the code works on that
> >> sheet. so some sheets it works, others it does not.
> >> 7. On the sheet I need to trap the mouse, all code in your test works,
> >> except the left mouse. In other sheets it traps everything
> >> 8. When I use only
> >> MsgBox GetAsyncKeyState(vbKeyLButton)
> >> in my Worksheet_SelectionChange, it shows just 0 (zero).
>
> >> 
> >> *rips hair out*
> >> 
>
> >> Anyone have ideas on how to determine why my sheet doesnt work, but a
> >> blank fresh one does?
>
> >> --
>
> >> ---
> >>  ---
> >> 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 athttp://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks athttp://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 
> > *akoul*.wordpress.com 
> > My Linkedin Profile 
>
> > P Before printing, think about the environment.
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.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$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

[ashish koul]

r u using right button also

On Wed, Feb 9, 2011 at 7:53 PM, ashish koul  wrote:

> can you share your workbook
>
> On Wed, Feb 9, 2011 at 6:57 PM, rcamarda wrote:
>
>> Ashish,
>> 1. Your code worked from your example.
>> 2. in my other tests, I added added the "= 1" I had, and some of my
>> test sheets worked.
>> 3. It didnt work when i put it into my sheet where I needed it,
>> GetAsyncKeyState(vbKeyLButton) = 1 And &H8000 but it didnt work
>> 4. I opened a fresh excel, pasted your code and it worked.
>> 5. My sheet has macro enabled, so I saved your test book as xlsm and
>> your test still works.
>> 6. I can create a new sheet in my excel, and the code works on that
>> sheet. so some sheets it works, others it does not.
>> 7. On the sheet I need to trap the mouse, all code in your test works,
>> except the left mouse. In other sheets it traps everything
>> 8. When I use only
>> MsgBox GetAsyncKeyState(vbKeyLButton)
>> in my Worksheet_SelectionChange, it shows just 0 (zero).
>>
>>
>> 
>> *rips hair out*
>> 
>>
>>
>> Anyone have ideas on how to determine why my sheet doesnt work, but a
>> blank fresh one does?
>>
>> --
>>
>> --
>> 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 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
>


-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.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$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

[ashish koul]

can you share your workbook

On Wed, Feb 9, 2011 at 6:57 PM, rcamarda  wrote:

> Ashish,
> 1. Your code worked from your example.
> 2. in my other tests, I added added the "= 1" I had, and some of my
> test sheets worked.
> 3. It didnt work when i put it into my sheet where I needed it,
> GetAsyncKeyState(vbKeyLButton) = 1 And &H8000 but it didnt work
> 4. I opened a fresh excel, pasted your code and it worked.
> 5. My sheet has macro enabled, so I saved your test book as xlsm and
> your test still works.
> 6. I can create a new sheet in my excel, and the code works on that
> sheet. so some sheets it works, others it does not.
> 7. On the sheet I need to trap the mouse, all code in your test works,
> except the left mouse. In other sheets it traps everything
> 8. When I use only
> MsgBox GetAsyncKeyState(vbKeyLButton)
> in my Worksheet_SelectionChange, it shows just 0 (zero).
>
>
> 
> *rips hair out*
> 
>
>
> Anyone have ideas on how to determine why my sheet doesnt work, but a
> blank fresh one does?
>
> --
>
> --
> 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 
*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$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

[rcamarda]

Ashish,
1. Your code worked from your example.
2. in my other tests, I added added the "= 1" I had, and some of my
test sheets worked.
3. It didnt work when i put it into my sheet where I needed it,
GetAsyncKeyState(vbKeyLButton) = 1 And &H8000 but it didnt work
4. I opened a fresh excel, pasted your code and it worked.
5. My sheet has macro enabled, so I saved your test book as xlsm and
your test still works.
6. I can create a new sheet in my excel, and the code works on that
sheet. so some sheets it works, others it does not.
7. On the sheet I need to trap the mouse, all code in your test works,
except the left mouse. In other sheets it traps everything
8. When I use only
MsgBox GetAsyncKeyState(vbKeyLButton)
in my Worksheet_SelectionChange, it shows just 0 (zero).



*rips hair out*



Anyone have ideas on how to determine why my sheet doesnt work, but a
blank fresh one does?

-- 
--
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: GetAsyncKeyState not working window 7 office 2010 x64

[rcamarda]

Sorry for the rabbit hole...I posted too quickly and once it was sent,
I couldnt retract.

I still can not get it to work.

Latest I tried is this, which always says left click has been pressed

code:

On a module I have:  Public Declare Function GetAsyncKeyState Lib
"user32" (ByVal vKey As Long) As Integer

(some postings change the return type and the parameter types)

In my sheet I have:
Sub Worksheet_SelectionChange(ByVal Target As Range)
If (GetAsyncKeyState(vbKeyRButton)) Then
MsgBox "You have clicked the right button!" 'when you click right
button

ElseIf (GetAsyncKeyState(vbKeyLButton) ) Then
MsgBox "You have clicked the left button!" 'when you click left button
End If


End Sub

I checked out: 
http://itknowledgeexchange.techtarget.com/beyond-excel/back-to-controlling-the-cursor/
and noticed how the author "cheated" when it came to mouse :)

I've added the &H8000 bit mask, but still nothing on the left mouse
click.

On Feb 9, 3:52 am, ashish koul  wrote:
> hi dave
>
> check this link see if 
> helpshttp://itknowledgeexchange.techtarget.com/beyond-excel/back-to-contro...
>
> On Wed, Feb 9, 2011 at 2:08 PM, Dave Bonallack 
> wrote:
>
>
>
>
>
> > Thanks Ashish,
> > Works great.
> > Regards - Dave.
>
> > --
> > Date: Wed, 9 Feb 2011 10:32:26 +0530
>
> > Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7
> > office 2010 x64
> > From: koul.ash...@gmail.com
> > To: excel-macros@googlegroups.com
>
> > try this
>
> > On Wed, Feb 9, 2011 at 10:27 AM, ashish koul wrote:
>
> > @ dave Try this
>
> >  Wed, Feb 9, 2011 at 9:55 AM, Dave Bonallack 
> > wrote:
>
> > Hi Ashish,
> > Thanks for sending the file. Excellent. But for some reason, selecting a
> > cell with the left mouse button isn't recognised. I tried adding Rob's code,
> > but it didn't work properly either. It only worked when using the left mouse
> > button to 'OK' a previous message box.
> > Regards - Dave
>
> > --
> > Date: Wed, 9 Feb 2011 09:03:03 +0530
> > Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7
> > office 2010 x64
> > From: koul.ash...@gmail.com
>
> > To: excel-macros@googlegroups.com
>
> > hi dave,
>
> > see if this helps
>
> > On Wed, Feb 9, 2011 at 5:52 AM, Dave Bonallack 
> > wrote:
>
> > Hi Rob,
> > I am interested in the trapping of a left mouse click, but couldn't
> > understand it from your posts. Could you please attach a workbook
> > with working code?
> > Regards - Dave.
>
> > > Date: Tue, 8 Feb 2011 05:14:53 -0800
> > > Subject: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7
> > office 2010 x64
> > > From: robert.a.cama...@gmail.com
> > > To: excel-macros@googlegroups.com
>
> > > solved it:
> > > I had to add a bit mask (i think thats what its called).
>
> > > This returned true when I clicked on a cell:
>
> > > If CBool(GetAsyncKeyState(1) & 128) Then
> > > MsgBox ("left click trapped")
> > > End If
>
> > > (1) is the constant for left mouse click
>
> > > On Feb 7, 11:28 am, rcamarda  wrote:
> > > > Hi,
> > > > I am trying to trap a left mouse click. I found lots of uses of
> > > > GetAsyncKeyState, however, even something simple is not working.
>
> > > > Private Declare Function GetAsyncKeyState Lib "user32.dll" (ByVal vKey
> > > > As Long) As Integer
>
> > > > Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>
> > > > If GetAsyncKeyState(VK_LBUTTON) Then
> > > >     MsgBox ("left click trapped")
> > > > End If
>
> > > > If GetAsyncKeyState(VK_BACK) Then
> > > >     MsgBox ("back space")
> > > > End If
>
> > > > If GetAsyncKeyState(VK_RETURN) Then
> > > >     MsgBox ("enter key")
> > > > End If
>
> > > > End Sub
>
> > > > Should I use a different library when using x64 or Office 2010??
> > > > TIA
> > > > Rob
>
> > > --
>
> > ---­---
> > > 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 athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip

$$Excel-Macros$$ Shorting Problems

[sudhir kumar]

Dear Frnd

I have list which have many repeated names
i want short it with formula


thanx

-- 
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
Sudhir Verma
Asstt. Mngr. A/c's
9818479722
*
P think Before you print
*
*
**
Life is Very beautiful !!!
*
*
¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!
 `•.¸.•´.
*
*
*
 *Happy **Valentine** Day  *
  \ ¦ /
 (ò ó)
_ ___o0o___(_)___o0o__
___¦_¦_¦_¦_¦
¦_¦_¦_¦_¦__
___¦_¦_¦_¦_¦

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


Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ Excel Charts/Pivots/VBA Newsletter

[Tolontino Gomes]

Can some one help me in the following problems with excel 2003?

When I save file a .tmp file saves and when I delete again .tmp saves along 
with the orginal .xls file

Please help

Reply me on tolontino.go...@pepsidrc.ae





From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of OpenExcel.com
Sent: Wednesday, February 09, 2011 2:13 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel Charts/Pivots/VBA Newsletter

Hey Friends,

Here is something interesting for you. Love is in the air, do some automation 
and save your time for your loved ones. Hope this helps you :)



1.  Collection of VBA 
Macros

2. Access a search Engine like Google, Bing or E-Bay on Internet Explorer using 
VBA

3. Learn how to use VLOOKUP 
function.

4. Remove VBA Code using 
VBA

5. Export Excel Charts to 
Powerpoint

6. Embed Adobe Flash in MS 
Excel

7. Learn how to use ARRAY 
Formulas

8. Validate E-mail 
addresses

9. Schedule a VBA 
Macro

10. Speed up Excel Start up (FASTER 
EXCEL)

11. Shrink or Reduce Excel File Size (From MBs to 
KBs)







Excel VBA Interview 
Questions 
 Collection of Excel VBA 
Macros
  
VLOOKUP 
 
OFFSET
  ARRAY 
formulas

Excel 2003 Style Menu in Excel 
2007
Custom Number 
Format
  
SUMIFS
  CONTACT a 
TRAINER






Thanks & Regards

Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com

Facebook 
Twitter 
LinkedIn  
LiveJournal   
Digg   
Delicious
   Subscribe to 
Email


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

$$Excel-Macros$$ Excel Charts/Pivots/VBA Newsletter

[OpenExcel.com]

Hey Friends,

Here is something interesting for you. *Love is in the air*, do some 
automation and *save your time for your loved ones*. Hope this helps you :)



1.  Collection of VBA 
Macros

2. Access a search Engine like Google, Bing or E-Bay on Internet Explorer 
using 
VBA

3. Learn how to use VLOOKUP 
function.

4. Remove VBA Code using 
VBA

5. Export Excel Charts to 
Powerpoint

6. Embed Adobe Flash in MS 
Excel

7. Learn how to use ARRAY 
Formulas

8. Validate E-mail 
addresses

9. Schedule a VBA 
Macro

10. Speed up Excel Start up (FASTER 
EXCEL)

11. Shrink or Reduce Excel File Size (From MBs to 
KBs)






--
Excel VBA Interview 
Questions
  Collection of Excel VBA 
Macros
  
VLOOKUP
  
OFFSET
  ARRAY 
formulas
 
--
Excel 2003 Style Menu in Excel 
2007
Custom Number 
Format
   
   
SUMIFS
  CONTACT a 
TRAINER
--





Thanks & Regards
--
Ashish Jain 
(Microsoft Certified Application Specialist) 
(Microsoft Certified Professional) 
http://www.excelitems.com 
http://www.openexcel.com 

Facebook  
Twitter
 LinkedIn   
LiveJournal
   Digg    
Delicious
   Subscribe to 
Email
--

-- 
--
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: GetAsyncKeyState not working window 7 office 2010 x64

[ashish koul]

hi dave

check this link see if helps
http://itknowledgeexchange.techtarget.com/beyond-excel/back-to-controlling-the-cursor/

On Wed, Feb 9, 2011 at 2:08 PM, Dave Bonallack wrote:

> Thanks Ashish,
> Works great.
> Regards - Dave.
>
> --
> Date: Wed, 9 Feb 2011 10:32:26 +0530
>
> Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7
> office 2010 x64
> From: koul.ash...@gmail.com
> To: excel-macros@googlegroups.com
>
> try this
>
> On Wed, Feb 9, 2011 at 10:27 AM, ashish koul wrote:
>
>
> @ dave Try this
>
>
>
>
>  Wed, Feb 9, 2011 at 9:55 AM, Dave Bonallack wrote:
>
> Hi Ashish,
> Thanks for sending the file. Excellent. But for some reason, selecting a
> cell with the left mouse button isn't recognised. I tried adding Rob's code,
> but it didn't work properly either. It only worked when using the left mouse
> button to 'OK' a previous message box.
> Regards - Dave
>
> --
> Date: Wed, 9 Feb 2011 09:03:03 +0530
> Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7
> office 2010 x64
> From: koul.ash...@gmail.com
>
> To: excel-macros@googlegroups.com
>
> hi dave,
>
> see if this helps
>
> On Wed, Feb 9, 2011 at 5:52 AM, Dave Bonallack 
> wrote:
>
> Hi Rob,
> I am interested in the trapping of a left mouse click, but couldn't
> understand it from your posts. Could you please attach a workbook
> with working code?
> Regards - Dave.
>
> > Date: Tue, 8 Feb 2011 05:14:53 -0800
> > Subject: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7
> office 2010 x64
> > From: robert.a.cama...@gmail.com
> > To: excel-macros@googlegroups.com
>
> >
> > solved it:
> > I had to add a bit mask (i think thats what its called).
> >
> > This returned true when I clicked on a cell:
> >
> > If CBool(GetAsyncKeyState(1) & 128) Then
> > MsgBox ("left click trapped")
> > End If
> >
> > (1) is the constant for left mouse click
> >
> > On Feb 7, 11:28 am, rcamarda  wrote:
> > > Hi,
> > > I am trying to trap a left mouse click. I found lots of uses of
> > > GetAsyncKeyState, however, even something simple is not working.
> > >
> > > Private Declare Function GetAsyncKeyState Lib "user32.dll" (ByVal vKey
> > > As Long) As Integer
> > >
> > > Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> > >
> > > If GetAsyncKeyState(VK_LBUTTON) Then
> > > MsgBox ("left click trapped")
> > > End If
> > >
> > > If GetAsyncKeyState(VK_BACK) Then
> > > MsgBox ("back space")
> > > End If
> > >
> > > If GetAsyncKeyState(VK_RETURN) Then
> > > MsgBox ("enter key")
> > > End If
> > >
> > > End Sub
> > >
> > > Should I use a different library when using x64 or Office 2010??
> > > TIA
> > > Rob
> >
> > --
> >
> --
> > 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 
> *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
>
> <><><><><><><><><><><><><><><><><><>

RE: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 2010 x64

[Dave Bonallack]

Thanks Ashish,
Works great.
Regards - Dave.
 


Date: Wed, 9 Feb 2011 10:32:26 +0530
Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 
2010 x64
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com

try this 


On Wed, Feb 9, 2011 at 10:27 AM, ashish koul  wrote:



@ dave Try this 



 
 
 
 
 Wed, Feb 9, 2011 at 9:55 AM, Dave Bonallack  wrote:


Hi Ashish,
Thanks for sending the file. Excellent. But for some reason, selecting a cell 
with the left mouse button isn't recognised. I tried adding Rob's code, but it 
didn't work properly either. It only worked when using the left mouse button to 
'OK' a previous message box.
Regards - Dave
 


Date: Wed, 9 Feb 2011 09:03:03 +0530
Subject: Re: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 
2010 x64
From: koul.ash...@gmail.com 



To: excel-macros@googlegroups.com


hi dave,
 
see if this helps 


On Wed, Feb 9, 2011 at 5:52 AM, Dave Bonallack  
wrote:


Hi Rob,
I am interested in the trapping of a left mouse click, but couldn't understand 
it from your posts. Could you please attach a workbook with working code?
Regards - Dave.
 
> Date: Tue, 8 Feb 2011 05:14:53 -0800
> Subject: $$Excel-Macros$$ Re: GetAsyncKeyState not working window 7 office 
> 2010 x64
> From: robert.a.cama...@gmail.com
> To: excel-macros@googlegroups.com 



> 
> solved it:
> I had to add a bit mask (i think thats what its called).
> 
> This returned true when I clicked on a cell:
> 
> If CBool(GetAsyncKeyState(1) & 128) Then
> MsgBox ("left click trapped")
> End If
> 
> (1) is the constant for left mouse click
> 
> On Feb 7, 11:28 am, rcamarda  wrote:
> > Hi,
> > I am trying to trap a left mouse click. I found lots of uses of
> > GetAsyncKeyState, however, even something simple is not working.
> >
> > Private Declare Function GetAsyncKeyState Lib "user32.dll" (ByVal vKey
> > As Long) As Integer
> >
> > Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> >
> > If GetAsyncKeyState(VK_LBUTTON) Then
> > MsgBox ("left click trapped")
> > End If
> >
> > If GetAsyncKeyState(VK_BACK) Then
> > MsgBox ("back space")
> > End If
> >
> > If GetAsyncKeyState(VK_RETURN) Then
> > MsgBox ("enter key")
> > End If
> >
> > End Sub
> >
> > Should I use a different library when using x64 or Office 2010??
> > TIA
> > Rob
> 
> -- 
> --
> 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
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, sen

Re: $$Excel-Macros$$ help pls : find first non empty row in range

[pawel lupinski]

thanks!!!





From: danial mansoor 
To: excel-macros@googlegroups.com
Sent: Wed, February 9, 2011 4:02:58 AM
Subject: RE: $$Excel-Macros$$ help pls : find first non empty row in range

  use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an 
array formula it ll give u 7 answer.u 


=MAX(IF(E17:E26>0,E17:E26))






> Date: Tue, 8 Feb 2011 17:05:33 -0800
> Subject: $$Excel-Macros$$ help pls : find first non empty row in range
> From: lupins...@yahoo.com
> To: excel-macros@googlegroups.com
> 
> Hi All,
> I hope you will help me in maybe something that is so simple, but I've
> sent last 2 hours to sort it out without any conclusion. :(
> The problem is: I need to find first cell that is bigger then 0 in the
> specific range.
> HELP!!!
> 
> PS I'd like to add an attachement but I don't know how, so e.g.:
> 
> column X
> 0
> 0
> 0
> 0
> 7
> 6
> 7
> 0
> 0
> 0
> 
> -- 
>--
>-
> 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



 

Get your own web address.  
Have a HUGE year through Yahoo! Small Business.
http://smallbusiness.yahoo.com/domains/?p=BESTDEAL

-- 
--
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 pls : find first non empty row in range

[pawel lupinski]

thanks a lot!!! superb





From: ashish koul 
To: excel-macros@googlegroups.com
Sent: Wed, February 9, 2011 5:33:44 AM
Subject: Re: $$Excel-Macros$$ help pls : find first non empty row in range


check the attachment
 

 
On Wed, Feb 9, 2011 at 8:32 AM, danial mansoor  wrote:

use this formula with NOT ONLY PRESS ENTER,PRESS CONTROL+SHIFT+ENTER its an 
array formula it ll give u 7 answer.u 

>
>=MAX(IF(E17:E26>0,E17:E26))
>
>
>
>
>
>
>> Date: Tue, 8 Feb 2011 17:05:33 -0800
>> Subject: $$Excel-Macros$$ help pls : find first non empty row in range
>> From: lupins...@yahoo.com
>> To: excel-macros@googlegroups.com 
>
>> 
>> Hi All,
>> I hope you will help me in maybe something that is so simple, but I've
>> sent last 2 hours to sort it out without any conclusion. :(
>> The problem is: I need to find first cell that is bigger then 0 in the
>> specific range.
>> HELP!!!
>> 
>> PS I'd like to add an attachement but I don't know how, so e.g.:
>> 
>> column X
>> 0
>> 0
>> 0
>> 0
>> 7
>> 6
>> 7
>> 0
>> 0
>> 0
>> 
>> -- 
>>--
>>-
>> 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
akoul.wordpress.com
My Linkedin Profile
 
 
PBefore 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



 

The fish are biting. 
Get more visitors on your site using Yahoo! Search Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php

-- 
--
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 CONVERT THE AMOUNT IN TEXT

[Amir Khan]

This is a very important tool to convert no. in figures into words:



STEPS:



1) Download the attachment and save it to hard disk.

2) Open excels and goes to Tools -Add Ins

3) Go to browse and select the smb.xla file from the location where u saved
it and click OK.



USE the Formula =ntow (amount in figure or cell reference

Regards

Amir

On Tue, Feb 8, 2011 at 2:10 PM, solomon raju  wrote:

> Vishal,
>
> Thank you very much.
> Regards,
> Solomon
>
> On Tue, Feb 8, 2011 at 12:19 PM, Vishal Gupta wrote:
>
>> Hi Soloman,
>> Try the sheet attached by me, it will definitly help you.
>>
>> Regards
>> CA. Vishal Gupta
>> 9463647598
>>
>>
>>
>> On Thu, Feb 3, 2011 at 4:44 PM, solomon raju wrote:
>>
>>>  Hi All,
>>>
>>> Please find the attached excel file and give me some formula to convert
>>> the amount in text.
>>>
>>> Regards,
>>> Solomon
>>>
>>> --
>>>
>>> --
>>> 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,
> Solomon
>
>  --
>
> --
> 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


smb.xla
Description: Binary data