Re: $$Excel-Macros$$ shortcut key .

[Ms-Exl-Learner .]

The same is applicable for removing filter also.

---
Ms.Exl.Learner
---

On Sun, Dec 18, 2011 at 12:17 PM, vijayajith VA wrote:

> Sorry . that is for put filter and remove filter.i need to clear checked
> items .in filtered coloumn.
>
>
> On Sun, Dec 18, 2011 at 12:10 PM, Ms-Exl-Learner . <
> ms.exl.lear...@gmail.com> wrote:
>
>> Alt+D+F+F
>>
>> ---
>> Ms.Exl.Learner
>> ---
>>
>>
>> On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA 
>> wrote:
>>
>>> Hello sir
>>>
>>> Can you tell me what is shortcut key for data clear(filter)?
>>>
>>>
>>> Thanks
>>>
>>> --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>  --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ shortcut key .

[vijayajith VA]

Sorry . that is for put filter and remove filter.i need to clear checked
items .in filtered coloumn.


On Sun, Dec 18, 2011 at 12:10 PM, Ms-Exl-Learner .  wrote:

> Alt+D+F+F
>
> ---
> Ms.Exl.Learner
> ---
>
>
> On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA 
> wrote:
>
>> Hello sir
>>
>> Can you tell me what is shortcut key for data clear(filter)?
>>
>>
>> Thanks
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ shortcut key .

[Ms-Exl-Learner .]

Alt+D+F+F

---
Ms.Exl.Learner
---

On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA wrote:

> Hello sir
>
> Can you tell me what is shortcut key for data clear(filter)?
>
>
> Thanks
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ shortcut key .

[vijayajith VA]

HI andy,


A Filter button [image: Applied filter icon] means that a filter is
applied.-I want to clear ths applied filter .for that i need short cut key
.i refered your link. i dint get it please hlp me

Thanks for your reply


On Sun, Dec 18, 2011 at 10:55 AM, Aindril De  wrote:

> Hi
>
> Try this:
>
> http://dmcritchie.mvps.org/excel/shortx2k.htm
>
> Cheers,
> andy
>
> On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA 
> wrote:
>
>> Hello sir
>>
>> Can you tell me what is shortcut key for data clear(filter)?
>>
>>
>> Thanks
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ shortcut key .

[Aindril De]

Hi

Try this:

http://dmcritchie.mvps.org/excel/shortx2k.htm

Cheers,
andy

On Sun, Dec 18, 2011 at 10:41 AM, vijayajith VA wrote:

> Hello sir
>
> Can you tell me what is shortcut key for data clear(filter)?
>
>
> Thanks
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ shortcut key .

[vijayajith VA]

Hello sir

Can you tell me what is shortcut key for data clear(filter)?


Thanks

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ VBA select data in BOLD

[dguillett1]

Did you run it on the file I sent you? I just retested xl2003, xl2007, xl2010 
and it worked just fine on all. Send YOUR file.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Cab Boose 
Sent: Saturday, December 17, 2011 6:17 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ VBA select data in BOLD




On Sun, Dec 18, 2011 at 9:18 AM, dguillett1  wrote:


Attached wbook





Hi Don
This happens when I run the code-
Highlights SearchFormat:=
with msg: Compile error
Named argument not found
r1 = Range(Cells(1, "g"), Cells(lr, "g")).Find(What:="", After:=Cells(sr, "G"), 
LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, SearchFormat:=True).Row


Thanks

Charlie Harris



  Don Guillett
  SalesAid Software
  dguille...@gmail.com









  From: Cab Boose 
  Sent: Saturday, December 17, 2011 2:05 PM
  To: excel-macros@googlegroups.com 
  Subject: Re: $$Excel-Macros$$ VBA select data in BOLD

  Hi Don & Noorain

  Thanks for your comments and ideas.

  I am taking one of our address lists and reducing the information in it as we 
will be doing everything by email and phone. Address etc not now required. Will 
also once this first task finished then classify into Catergory types for 
industries etc. A small 7 person business with some manufacturing and also 
online sales being developed.   Overall it leaves us with just the information 
we need.  The example is only a portion of the workbook.

  My apologies for not mentioning that not all companies will have a phone #  
and/or  email address.

  Regards

  Charlie Harris

   
  On Sun, Dec 18, 2011 at 5:22 AM, NOORAIN ANSARI  
wrote:

Dear Cab Boose,

Please use try function.

Copy this formula and paste it in define name and provide name range IsBold
=GET.CELL(20,INDIRECT("RC[1]",FALSE)) 

See attached sheet for reference 


-- 

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

On Sat, Dec 17, 2011 at 3:16 AM, Cab Boose  wrote:

  Hi Don

  The new code works well for the first few lines and then starts to repeat 
the same Phone number and same email address even though it has the company 
name correct.  A strange thing.  Note that athe repeat starts on the same row 
as the first email in G ?

  See attached.  

  Thanks and regards

  Charlie


  On Sat, Dec 17, 2011 at 3:29 AM, dguillett1  wrote:

should do it

Option Explicit
Sub foreachcoSAS()
Dim lr As Long
Dim dlr As Long
Dim i As Long
Dim ph As Long
Dim em As Long
Dim c As Range
i = 1
lr = Cells(Rows.Count, "g").End(xlUp).Row
For Each c In Range("g1:g" & lr)
dlr = Cells(Rows.Count, "H").End(xlUp).Row + 1
If c.Font.Bold Then
'MsgBox c
ph = Columns("g").Find(What:="ph", After:=Cells(i, "G"), 
LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
'MsgBox ph
em = Columns("g").Find(What:="email", After:=Cells(i, "G"), 
LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
'MsgBox em
Cells(dlr, "H").Value = Cells(c.Row, "g").Value
Cells(dlr, "i").Value = Cells(ph, "g").Value
Cells(dlr, "j").Value = Cells(em, "g").Value
i = i + em
End If
Next
Columns("H:j").AutoFit
End Sub

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Cab Boose 
Sent: Friday, December 16, 2011 12:28 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ VBA select data in BOLD

Hi Don
Thanks for code. Wow it works great and fast.
In the line of code that puts the info into col H , how do I put into 3 
different colums ? Say H, I, J. 
I could run text to columns on the result but would prefer to do it 
with code
Thanks
Charlie



On Fri, Dec 16, 2011 at 1:56 PM, dguillett1  
wrote:

  One way

  Option Explicit

  Sub foreachcoSAS()
  Dim lr As Long
  Dim i As Long
  Dim ph As Long
  Dim em As Long
  Dim c As Range
  Dim ms As String

  i = 1
  lr = Cells(Rows.Count, "g").End(xlUp).Row
  For Each c In Range("g1:g" & lr)
  If c.Font.Bold Then
  'MsgBox c
  ph = Columns("g").Find(What:="ph", After:=Cells(i, "G"), 
LookIn:=xlValues, _
  LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
  'MsgBox ph
  em = Columns("g").Find(What:="email", After:=Cells(i, "G"), 
LookIn:=xlValues, _
  LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
  'MsgBox em
  ms = Cells(c.Row, "g") & " " & Cells(ph, "g") & " " & Cells(em, "

Re: $$Excel-Macros$$ VBA select data in BOLD

[Cab Boose]

On Sun, Dec 18, 2011 at 9:18 AM, dguillett1  wrote:

Attached wbook





Hi Don
 This happens when I run the code-
   Highlights *SearchFormat:=*
 with msg: Compile error
 Named argument not found
  r1 = Range(Cells(1, "g"), Cells(lr, "g")).Find(What:="", After:=Cells(sr,
"G"), LookIn:=xlValues, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False _
, *SearchFormat:=*True).Row


Thanks

Charlie Harris




>  Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>







>
>
>  *From:* Cab Boose 
> *Sent:* Saturday, December 17, 2011 2:05 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ VBA select data in BOLD
>
>  Hi Don & Noorain
> Thanks for your comments and ideas.
>
> I am taking one of our address lists and reducing the information in it as
> we will be doing everything by email and phone. Address etc not now
> required. Will also once this first task finished then classify into
> Catergory types for industries etc. A small 7 person business with some
> manufacturing and also online sales being developed.   Overall it leaves us
> with just the information we need.  The example is only a portion of the
> workbook.
>
> My apologies for not mentioning that not all companies will have a phone
> #  and/or  email address.
>
> Regards
>
> Charlie Harris
>
>
> On Sun, Dec 18, 2011 at 5:22 AM, NOORAIN ANSARI 
> wrote:
>
>> Dear Cab Boose,
>>
>> Please use try function.
>>
>> Copy this formula and paste it in define name and provide name range *
>> IsBold
>> =GET.CELL(20,INDIRECT("RC[1]",FALSE))
>>
>> See attached sheet for reference
>> *
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>> On Sat, Dec 17, 2011 at 3:16 AM, Cab Boose  wrote:
>>
>>> Hi Don
>>>
>>> The new code works well for the first few lines and then starts to
>>> repeat the same Phone number and same email address even though it has the
>>> company name correct.  A strange thing.  Note that athe repeat starts on
>>> the same row as the first email in G ?
>>>
>>> See attached.
>>>
>>> Thanks and regards
>>>
>>> Charlie
>>>
>>>  On Sat, Dec 17, 2011 at 3:29 AM, dguillett1 wrote:
>>>
   should do it

 Option Explicit
 Sub foreachcoSAS()
 Dim lr As Long
 Dim dlr As Long
  Dim i As Long
 Dim ph As Long
 Dim em As Long
 Dim c As Range
  i = 1
 lr = Cells(Rows.Count, "g").End(xlUp).Row
 For Each c In Range("g1:g" & lr)
 dlr = Cells(Rows.Count, "H").End(xlUp).Row + 1
  If c.Font.Bold Then
 'MsgBox c
 ph = Columns("g").Find(What:="ph", After:=Cells(i, "G"),
 LookIn:=xlValues, _
 LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
 'MsgBox ph
 em = Columns("g").Find(What:="email", After:=Cells(i, "G"),
 LookIn:=xlValues, _
 LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
 'MsgBox em
 Cells(dlr, "H").Value = Cells(c.Row, "g").Value
 Cells(dlr, "i").Value = Cells(ph, "g").Value
 Cells(dlr, "j").Value = Cells(em, "g").Value
  i = i + em
 End If
 Next
 Columns("H:j").AutoFit
  End Sub

 Don Guillett
 SalesAid Software
 dguille...@gmail.com

  *From:* Cab Boose 
 *Sent:* Friday, December 16, 2011 12:28 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ VBA select data in BOLD

   Hi Don
  Thanks for code. Wow it works great and fast.
  In the line of code that puts the info into col H , how do I put into
 3 different colums ? Say H, I, J.
  I could run text to columns on the result but would prefer to do it
 with code
  Thanks
  Charlie


 On Fri, Dec 16, 2011 at 1:56 PM, dguillett1 wrote:

>   One way
>
> Option Explicit
>
> Sub foreachcoSAS()
> Dim lr As Long
> Dim i As Long
> Dim ph As Long
> Dim em As Long
> Dim c As Range
> Dim ms As String
>
> i = 1
> lr = Cells(Rows.Count, "g").End(xlUp).Row
> For Each c In Range("g1:g" & lr)
> If c.Font.Bold Then
> 'MsgBox c
> ph = Columns("g").Find(What:="ph", After:=Cells(i, "G"),
> LookIn:=xlValues, _
> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
> 'MsgBox ph
> em = Columns("g").Find(What:="email", After:=Cells(i, "G"),
> LookIn:=xlValues, _
> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
> 'MsgBox em
> ms = Cells(c.Row, "g") & " " & Cells(ph, "g") & " " & Cells(em, "g")
> Cells(Rows.Count, "h").End(xlUp).Offset(1) = ms
> 'MsgBox ms
> i = i + em
> End If
> Next
> Columns("H").AutoFit
> End Sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Cab Boose 
> *Sent:* Thursday, December 15, 2011 4:12 PM
> *

RE: $$Excel-Macros$$ Compare character types in 2 character string

[Asa Rossoff]

Hi StephenM,
Sorry, correction:
=ISERROR(VALUE(LEFT(A1,1)))=ISERROR(VALUE(RIGHT(A1,1)))

is the correct formula for the below!
 :)
Asa

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Asa Rossoff
Sent: Saturday, December 17, 2011 3:33 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Compare character types in 2 character string

Hi StephenM,
=isnumber(left(a1,1))=isnumber(right(a1,1))

That will return TRUE if the first and last character are the same type
(numeric or non-numeric).

It will return FALSE if they are different types.

Asa

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of StephenM
Sent: Friday, December 16, 2011 9:58 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Compare character types in 2 character string

I have extracted 2 characters from a longer string. I need to
determine if both characters are the same type (both alphabetic, or
both numeric), else if they are a different character types. The order
of character types does  not matter, just if they are both the same
type. Please correct my terms if they are wrong.

The data looks like this. I would expect a function to tell me that
the values ZJ and 85 are the same type, and to tell me the values Q3
and R1 are different types.

Is this possible?

ZJ
85
Q3
R1

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Compare character types in 2 character string

[Asa Rossoff]

Hi StephenM,
=isnumber(left(a1,1))=isnumber(right(a1,1))

That will return TRUE if the first and last character are the same type
(numeric or non-numeric).

It will return FALSE if they are different types.

Asa

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of StephenM
Sent: Friday, December 16, 2011 9:58 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Compare character types in 2 character string

I have extracted 2 characters from a longer string. I need to
determine if both characters are the same type (both alphabetic, or
both numeric), else if they are a different character types. The order
of character types does  not matter, just if they are both the same
type. Please correct my terms if they are wrong.

The data looks like this. I would expect a function to tell me that
the values ZJ and 85 are the same type, and to tell me the values Q3
and R1 are different types.

Is this possible?

ZJ
85
Q3
R1

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

RE: $$Excel-Macros$$ urgent,can anyone teach me "Private Const LLKHF_ALTDOWN = &H20 "meaning

[Asa Rossoff]

Hi Garcia,

 

The key words and symbols in that line of code have the folowing meanings:

PRIVATE - Scope of the constant is limited to the current module.  Other
modules cannot access the constant.

CONST - Define/declare a constant (like a variable, but the value cannot be
modified.  It has a constant value)

LLKHF_ALTDOWN - the name of the constant.  Refer to it in code as you would
a variable to access it's value.  This particular constant name is part of
the Windows API (Application Programming Interface) used to define keyboard
hooks -- to have your code execute when keys are pressed.

&H - The literal value is specified in hexadecimal (base 16) form.  Digits
range from 0-F (0-9 and A-F).

 

Refer to http://msdn.microsoft.com/en-us/library/s9cz43ek.aspx for type
declaration characters, including the symbols for specifying hexadecimal and
octal literals.  The page is for Visual Basic .NET 2010, but is valid for
VBA as well.  The type declaration characters are listed individually on
MSDN/Excel help under the topics for each data type (Long, Integer, Double,
etc.).  I'm not sure if/where the symbols/characters for hex and octal
literals are specified in VBA help topics

 

Refer to http://msdn.microsoft.com/en-us/library/gg264363.aspx for help on
the CONST statement.  It also explains the use of PRIVATE and PUBLIC with
the CONST statement.  This page is also available in Excel's help facility.

 

Refer to http://www.codeguru.com/vb/gen/vb_system/keyboard/article.php/c4829
for an article about using keyboard hooks in VB6 (Visual Basic version 6).
I have not reviewed it to verify it is valid in VBA, but VBA is based on VB6
- the version of Visual Basic prior to Visual Basic .NET.

 

Refer to http://www.vbforums.com/showthread.php?t=333116 for a discussion of
using keyboard hooks in VBA, with some code.

 

Asa

 

 

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Garcia
Sent: Friday, December 16, 2011 12:44 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ urgent,can anyone teach me "Private Const
LLKHF_ALTDOWN = &H20 "meaning

 

Hi,expert,

what is mean of   "Private Const LLKHF_ALTDOWN = &H20 ", i find this

code in a key event VBA code, but i do not understand,can anyone help

me,also i do not know how to get "LLKHF_ALTDOWN" from MSDN about

"&H20" value, please your kindly help.

Thanks

 

-- 

FORUM RULES (934+ members already BANNED for violation)

 

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.

 

2) Don't post a question in the thread of another member.

 

3) Don't post questions regarding breaking or bypassing any security
measure.

 

4) Acknowledge the responses you receive, good or bad.

 

5)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 

 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

 


--

To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Mid Function

[hanumant shinde]

Hello Amir,

you can use below formula as well.

=LEFT(MID(A2,FIND(" ",A2)+1,FIND(" ",A2,FIND(" ",A2)+1)),FIND(" ",MID(A2,FIND(" 
",A2)+1,FIND(" ",A2,FIND(" ",A2)+1

but i think below formula is much shorter than this 1.  :) 




>
> From: Aamir Shahzad 
>To: excel-macros@googlegroups.com 
>Sent: Sunday, 18 December 2011 1:14 AM
>Subject: Re: $$Excel-Macros$$ Mid Function
> 
>
>Thanks Asa
>
>
>
>Aamir Shahzad
>
>On Sun, Dec 18, 2011 at 12:36 AM, Asa Rossoff  wrote:
>
>Hello Aamir,
>>You can use:
>>=MID(A2,FIND(" ",A2)+1,FIND(" ",A2,FIND(" ",A2)+1)-FIND(" ",A2))
>> 
>>Because the third argument to MID is the starting position, we can start the 
>>search for the second space after the first space. 
>>~Asa
>> 
>>From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
>>Behalf Of Aamir Shahzad
>>Sent: Saturday, December 17, 2011 11:04 AM
>>To: excel-macros@googlegroups.com
>>Subject: $$Excel-Macros$$ Mid Function
>> 
>>Dear Group,
>> 
>>When I am extracting the "Insulators" text by below mentioned mid function it 
>>shows only "Insulat", Please suggest what amendment required in this formula. 
>> 
>>Ceramic Insulators #124-TD45-87
>>
>> 
>>=MID(A2,FIND(" ",A2),FIND(" ",A2))
>>
>>-- 
>>Regards,
>>Aamir Shahzad
>> 
>>-- 
>>FORUM RULES (934+ members already BANNED for violation)
>> 
>>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
>>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
>>get quick attention or may not be answered.
>> 
>>2) Don't post a question in the thread of another member.
>> 
>>3) Don't post questions regarding breaking or bypassing any security measure.
>> 
>>4) Acknowledge the responses you receive, good or bad.
>> 
>>5) Cross-promotion of, or links to, forums competitive to this forum in 
>>signatures are prohibited. 
>> 
>>NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>>owners and members are not responsible for any loss.
>> 
>>--
>>To post to this group, send email to excel-macros@googlegroups.com
>>-- 
>>FORUM RULES (934+ members already BANNED for violation)
>> 
>>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
>>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
>>get quick attention or may not be answered.
>> 
>>2) Don't post a question in the thread of another member.
>> 
>>3) Don't post questions regarding breaking or bypassing any security measure.
>> 
>>4) Acknowledge the responses you receive, good or bad.
>> 
>>5)  Cross-promotion of, or links to, forums competitive to this forum in 
>>signatures are prohibited. 
>> 
>>NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
>>owners and members are not responsible for any loss.
>> 
>>--
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>-- 
>
>Regards,
>Aamir Shahzad
>-- 
>FORUM RULES (934+ members already BANNED for violation)
> 
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
> 
>2) Don't post a question in the thread of another member.
> 
>3) Don't post questions regarding breaking or bypassing any security measure.
> 
>4) Acknowledge the responses you receive, good or bad.
> 
>5)  Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited. 
> 
>NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
>owners and members are not responsible for any loss.
> 
>--
>To post to this group, send email to excel-macros@googlegroups.com
>
>
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Help on isblank & iferror

[Aamir Shahzad]

as desired

=IF(ISBLANK(A2),"",IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:$A$3,1,0)),"Not
Received",SUMIF(Sheet1!$A$2:$A$3,A2,Sheet1!$B$2:$B$3)))

See the attached sheet.

Aamir Shahzad

On Fri, Dec 16, 2011 at 5:44 PM, Vijayendra Rao wrote:

> Hi All,
>
> I want to put isblank and iferror formula in one cell. Can you please help.
>
> Attached sheet for your reference.
>
> Regards,
> Vijayendra
> 94491 67631
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> 
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Regards,

Aamir Shahzad

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


isblank & iferror together.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help on isblank & iferror

[dguillett1]

=IF(A3="","",IFERROR(VLOOKUP(A3,Sheet1!$A:$A,1,0),"not recieved"))

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Vijayendra Rao 
Sent: Friday, December 16, 2011 6:44 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Help on isblank & iferror

Hi All,

I want to put isblank and iferror formula in one cell. Can you please help.

Attached sheet for your reference.
 
Regards,
Vijayendra
94491 67631

-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need a macro to update charts automatically

[dguillett1]

Please explain your need


Don Guillett
SalesAid Software
dguille...@gmail.com

From: Atul vishwakarma 
Sent: Thursday, December 15, 2011 8:29 PM
To: MS EXCEL AND VBA MACROS 
Subject: $$Excel-Macros$$ Need a macro to update charts automatically

Hi Friends,

I need a macro to update charts automatically. Attached is sample file.

Thanks!

--

Atul Vishwakarma
-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ help to make pivot table

[ashish koul]

http://www.contextures.com/xlpivot01.html

http://www.contextures.com/xlpivot04.html

http://www.contextures.com/tiptech.html

On Sat, Dec 17, 2011 at 9:46 AM, Ruchi Sharma  wrote:

> plzz tell me how to make a pivot table
>
>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*Regards*
* *
*Ashish Koul*
*http://www.excelvbamacros.com/*


P Before printing, think about the environment.

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ VBA select data in BOLD

[Cab Boose]

Hi Don & Noorain
Thanks for your comments and ideas.

I am taking one of our address lists and reducing the information in it as
we will be doing everything by email and phone. Address etc not now
required. Will also once this first task finished then classify into
Catergory types for industries etc. A small 7 person business with some
manufacturing and also online sales being developed.   Overall it leaves us
with just the information we need.  The example is only a portion of the
workbook.

My apologies for not mentioning that not all companies will have a phone #
and/or  email address.

Regards

Charlie Harris


On Sun, Dec 18, 2011 at 5:22 AM, NOORAIN ANSARI wrote:

> Dear Cab Boose,
>
> Please use try function.
>
> Copy this formula and paste it in define name and provide name range *
> IsBold
> =GET.CELL(20,INDIRECT("RC[1]",FALSE))
>
> See attached sheet for reference
> *
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Sat, Dec 17, 2011 at 3:16 AM, Cab Boose  wrote:
>
>> Hi Don
>>
>> The new code works well for the first few lines and then starts to repeat
>> the same Phone number and same email address even though it has the company
>> name correct.  A strange thing.  Note that athe repeat starts on the same
>> row as the first email in G ?
>>
>> See attached.
>>
>> Thanks and regards
>>
>> Charlie
>>
>> On Sat, Dec 17, 2011 at 3:29 AM, dguillett1  wrote:
>>
>>>   should do it
>>>
>>> Option Explicit
>>> Sub foreachcoSAS()
>>> Dim lr As Long
>>> Dim dlr As Long
>>> Dim i As Long
>>> Dim ph As Long
>>> Dim em As Long
>>> Dim c As Range
>>> i = 1
>>> lr = Cells(Rows.Count, "g").End(xlUp).Row
>>> For Each c In Range("g1:g" & lr)
>>> dlr = Cells(Rows.Count, "H").End(xlUp).Row + 1
>>> If c.Font.Bold Then
>>> 'MsgBox c
>>> ph = Columns("g").Find(What:="ph", After:=Cells(i, "G"),
>>> LookIn:=xlValues, _
>>> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
>>> 'MsgBox ph
>>> em = Columns("g").Find(What:="email", After:=Cells(i, "G"),
>>> LookIn:=xlValues, _
>>> LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
>>> 'MsgBox em
>>> Cells(dlr, "H").Value = Cells(c.Row, "g").Value
>>> Cells(dlr, "i").Value = Cells(ph, "g").Value
>>> Cells(dlr, "j").Value = Cells(em, "g").Value
>>> i = i + em
>>> End If
>>> Next
>>> Columns("H:j").AutoFit
>>> End Sub
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Cab Boose 
>>> *Sent:* Friday, December 16, 2011 12:28 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* Re: $$Excel-Macros$$ VBA select data in BOLD
>>>
>>>  Hi Don
>>>  Thanks for code. Wow it works great and fast.
>>>  In the line of code that puts the info into col H , how do I put into
>>> 3 different colums ? Say H, I, J.
>>>  I could run text to columns on the result but would prefer to do it
>>> with code
>>>  Thanks
>>>  Charlie
>>>
>>>
>>> On Fri, Dec 16, 2011 at 1:56 PM, dguillett1 wrote:
>>>
   One way

 Option Explicit

 Sub foreachcoSAS()
 Dim lr As Long
 Dim i As Long
 Dim ph As Long
 Dim em As Long
 Dim c As Range
 Dim ms As String

 i = 1
 lr = Cells(Rows.Count, "g").End(xlUp).Row
 For Each c In Range("g1:g" & lr)
 If c.Font.Bold Then
 'MsgBox c
 ph = Columns("g").Find(What:="ph", After:=Cells(i, "G"),
 LookIn:=xlValues, _
 LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
 'MsgBox ph
 em = Columns("g").Find(What:="email", After:=Cells(i, "G"),
 LookIn:=xlValues, _
 LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext).Row
 'MsgBox em
 ms = Cells(c.Row, "g") & " " & Cells(ph, "g") & " " & Cells(em, "g")
 Cells(Rows.Count, "h").End(xlUp).Offset(1) = ms
 'MsgBox ms
 i = i + em
 End If
 Next
 Columns("H").AutoFit
 End Sub

 Don Guillett
 SalesAid Software
 dguille...@gmail.com

  *From:* Cab Boose 
 *Sent:* Thursday, December 15, 2011 4:12 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ VBA select data in BOLD

   Hi

 Have addresses like this:   (columnG)

 ABC COMPANY
 123 Delta St
 Town
 Ph   0800123456
 fax  234567
 email1...@dfg.com

 Sometimes there are more rows with irrelvant informtation

 I want to select 3 of the rows :

 ABC COMPANY Ph  0800123456 email   1...@dfg.com

 And place them in  a single row in column A, B, C

 Company line will always be BOLD
 Phone line will always start with   'Ph'
 Email line will always start with 'email'  or have the '@'


 Once done the original codes will all be deleted leaving just the 3
 columns A-C
 I will do a sort then and get all the blank rows deleted.




 For Each cell 

$$Excel-Macros$$ Help on isblank & iferror

[Vijayendra Rao]

Hi All,

I want to put isblank and iferror formula in one cell. Can you please help.

Attached sheet for your reference.

Regards,
Vijayendra
94491 67631

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


isblank & iferror together.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Worksheet Combobox to list available macro

[johann]

Hi,

Does someone know how to list macros from current opened workbooks in
a worksheet control combobox? More precisely, I'd like to make a
reference or create an alias to a macro.

For instance: in the project window in the Vba editor in another
OPENED workbook I have a few macros like :
ArchPastValues - CreateNewValues - SearchPastValues - SearchNewValues

I'd like a combobow that would respectively list available macros from
opened workbooks but with more formal names (since space is not
allowed in a macro name) like :

Archive past values
Create new values
Search past values
Search new values

Any idea?

Johann

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Compare character types in 2 character string

[StephenM]

I have extracted 2 characters from a longer string. I need to
determine if both characters are the same type (both alphabetic, or
both numeric), else if they are a different character types. The order
of character types does  not matter, just if they are both the same
type. Please correct my terms if they are wrong.

The data looks like this. I would expect a function to tell me that
the values ZJ and 85 are the same type, and to tell me the values Q3
and R1 are different types.

Is this possible?

ZJ
85
Q3
R1

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Mid Function

[Norman Cliff May]

Try the following formula:

=IF(ISERR(MID(A2,FIND(" ",A2)+1,IF(ISERR(FIND(" ",A2,FIND(" ",A2)+1)),
FIND(" ",A2),FIND(" ",A2,FIND(" ",A2)+1))-FIND(" ",A2)-1)),"",MID(A2,FIND("
",A2)+ 1,IF(ISERR(FIND(" ",A2,FIND(" ",A2)+1)),FIND(" ",A2),FIND("
",A2,FIND(" ",A2)+1))-FIND(" ",A2)-1))

Norman

On Sat, Dec 17, 2011 at 2:03 PM, Aamir Shahzad wrote:

> Dear Group,
>
> When I am extracting the "Insulators" text by below mentioned mid function
> it shows only "Insulat", Please suggest what amendment required in this
> formula.
>
> Ceramic Insulators #124-TD45-87
>
> =MID(A2,FIND(" ",A2),FIND(" ",A2))
>
> --
>
> Regards,
>
> Aamir Shahzad
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Almost all calculator in one sheet

[Waseem Saifi]

thanx ankit,
   this is awesome.


and quite usefull.


On Thu, Dec 1, 2011 at 9:45 AM, Pranav N  wrote:

> Thanks.
>
> -Nas
>
>
> On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal <
> ankit.agrawal...@gmail.com> wrote:
>
>> Hello All,
>>
>> In our daily life we calculate so many thing & use different calculator.
>> Here is one excel file which contain almost all calculator.
>>
>>
>> Calculate & enjoy !!!
>>
>>
>> Regards,
>>
>> Ankit
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Median in Pivot Table

[Atul vishwakarma]

Hi Noorain,

Thanks for your response but I am disappoint to know that we cannot make
user define  function within Pivot

--
Atul

On Thu, Dec 15, 2011 at 11:05 AM, NOORAIN ANSARI
wrote:

> Dear Atul,
>
> Please see below link, hope it will help to u.
>
> http://www.digdb.com/excel_add_ins/median_pivot_table_roll_up/
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>
> On Thu, Dec 15, 2011 at 12:52 AM, Atul  wrote:
>
>> Hi Experts,
>>
>> Is there any possible way that I can build Median formula inside the
>> pivot table like average, sum count etc.
>>
>> Thanks!
>>
>> Regards,
>> Atul
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5)  Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE  : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ help to make pivot table

[Ruchi Sharma]

plzz tell me how to make a pivot table

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Mid Function

[Aamir Shahzad]

Thanks Asa

Aamir Shahzad

On Sun, Dec 18, 2011 at 12:36 AM, Asa Rossoff  wrote:

> Hello Aamir,
>
> You can use:
>
> =MID(A2,FIND(" ",A2)+1,FIND(" ",A2,FIND(" ",A2)+1)-FIND(" ",A2))
>
>
>
> Because the third argument to MID is the starting position, we can start
> the search for the second space after the first space.
>
> ~Asa
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Aamir Shahzad
> *Sent:* Saturday, December 17, 2011 11:04 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Mid Function
>
>
>
> Dear Group,
>
>
>
> When I am extracting the "Insulators" text by below mentioned mid function
> it shows only "Insulat", Please suggest what amendment required in this
> formula.
>
>
>
> Ceramic Insulators #124-TD45-87
>
>
>
> =MID(A2,FIND(" ",A2),FIND(" ",A2))
>
>
> --
>
> Regards,
>
> Aamir Shahzad
>
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Regards,

Aamir Shahzad

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Mid Function

[Asa Rossoff]

Hello Aamir,

You can use:

=MID(A2,FIND(" ",A2)+1,FIND(" ",A2,FIND(" ",A2)+1)-FIND(" ",A2))

 

Because the third argument to MID is the starting position, we can start the
search for the second space after the first space. 

~Asa

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: Saturday, December 17, 2011 11:04 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Mid Function

 

Dear Group,

 

When I am extracting the "Insulators" text by below mentioned mid function
it shows only "Insulat", Please suggest what amendment required in this
formula. 

 

Ceramic Insulators #124-TD45-87


 

=MID(A2,FIND(" ",A2),FIND(" ",A2))


-- 

Regards,

Aamir Shahzad

 

-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Mid Function

[Aamir Shahzad]

Dear Group,

When I am extracting the "Insulators" text by below mentioned mid function
it shows only "Insulat", Please suggest what amendment required in this
formula.

Ceramic Insulators #124-TD45-87

=MID(A2,FIND(" ",A2),FIND(" ",A2))

-- 

Regards,

Aamir Shahzad

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ regarding addins in vba

[Aamir Shahzad]

Noorain sb,

What about excel 2010 add in , if I want to create one add in (password
protected) where I can save all desired macros, UDF & if any buttons for
create customized commands.

Regards,

Aamir Shahzad

On Sat, Dec 17, 2011 at 11:10 PM, NOORAIN ANSARI
wrote:

> pfa
>
>
> 2011/12/17 NOORAIN ANSARI 
>
>> Dear Vijay,
>>
>> Please try it
>>
>> file:///D:/VBA%20Training/Add-In/excel-add-in-create.htm
>> http://www.ozgrid.com/Services/ExcelAdd-insPage.htm
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>> On Sat, Dec 17, 2011 at 11:44 AM, vijayajith VA 
>> wrote:
>>
>>> Hello sir,
>>>
>>> Please i want to know  about Add ins .Can you give me some examples?
>>>
>>> Thanks
>>> --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>>
>>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Regards,

Aamir Shahzad

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ regarding addins in vba

[vijayajith VA]

Thanks Noorain


On Sat, Dec 17, 2011 at 11:40 PM, NOORAIN ANSARI
wrote:

> pfa
>
>
> 2011/12/17 NOORAIN ANSARI 
>
>> Dear Vijay,
>>
>> Please try it
>>
>> file:///D:/VBA%20Training/Add-In/excel-add-in-create.htm
>> http://www.ozgrid.com/Services/ExcelAdd-insPage.htm
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>  *http://excelmacroworld.blogspot.com/*
>> *http://noorain-ansari.blogspot.com/*
>>
>> On Sat, Dec 17, 2011 at 11:44 AM, vijayajith VA 
>> wrote:
>>
>>> Hello sir,
>>>
>>> Please i want to know  about Add ins .Can you give me some examples?
>>>
>>> Thanks
>>>
>>> --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>>
>>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ regarding addins in vba

[NOORAIN ANSARI]

pfa

2011/12/17 NOORAIN ANSARI 

> Dear Vijay,
>
> Please try it
>
> file:///D:/VBA%20Training/Add-In/excel-add-in-create.htm
> http://www.ozgrid.com/Services/ExcelAdd-insPage.htm
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Sat, Dec 17, 2011 at 11:44 AM, vijayajith VA 
> wrote:
>
>> Hello sir,
>>
>> Please i want to know  about Add ins .Can you give me some examples?
>>
>> Thanks
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>
>


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

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Excel2003_Style_Menu.xlam
Description: application/vnd.ms-excel.addin.macroenabled.12


NetWorkingDays.xla
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

[NOORAIN ANSARI]

Dear Aamir,

Thanks...

*=VLOOKUP(D7,INDIRECT(TEXT(D5,"")&"!B2:C4"),2,FALSE)*
in above formula Indirect function is providing us full month name which
are also sheetname.
after using indirect function range is converting like
October!B2:C2,November!B2:C2,December!B2:C2, which is our requirement.

I hope you will understood..

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Sat, Dec 17, 2011 at 1:56 AM, Aamir Shahzad wrote:

> Dear Norrain sb,
>
> Wonderful solution by your end, Can you please tell me how indirect
> function finding the desired data into 3 different sheets. This logic I am
> not understanding.
>
> Regards,
>
> Aamir Shahzad
>
> On Fri, Dec 16, 2011 at 9:08 PM, vickey  wrote:
>
>> thank a lot
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
>
> Regards,
>
> Aamir Shahzad
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

[vickey]

Ofcorse it can hve macros, the idea behind it to store invoice data. If 
macros is being used then to make it more good other then active sheet can 
be hiden. Vickey

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Change return value of data from one sheet to other by entering value in cell

[dguillett1]

Does this have to be a formula or can you use macros?

Don Guillett
SalesAid Software
dguille...@gmail.com

From: vickey 
Sent: Saturday, December 17, 2011 3:35 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Change return value of data from one sheet to 
other by entering value in cell

Hi, further to my previous question,

I need one more help from you, since I am working on one Invoice, which require 
some modification. I have highlited the issue in callouts.

the major issue is to generate incremental Invoice no based on no of 
particulars mutiple itmes enterd in one invoice.

Hope I have put enough comment to give my thought, in case of any query related 
to issues please let me know.

attached sample file.

regards,

vickey
-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: Help On Print

[dguillett1]

attach or send me your file with a better explanation and examples.

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Shrinivas Shevde 
Sent: Friday, December 16, 2011 10:42 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Re: Help On Print

Dear Rohan

Thanks for the help.
But To filter I need to be present in front of the computer and I right now I 
want to take out the print for more than 2 years (nearly 600+ print)
So I want some kind of macro or something like where I can give "from date" to 
"to date" and I can do some other work

Regards
Shrinivas 


On Sat, Dec 17, 2011 at 2:49 AM, Rohan  wrote:

  Hi,

  You can do a filter and take a print out.!!


  Regards,
  Rohan.

  --
  FORUM RULES (934+ members already BANNED for violation)

  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

  2) Don't post a question in the thread of another member.

  3) Don't post questions regarding breaking or bypassing any security measure.

  4) Acknowledge the responses you receive, good or bad.

  5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.

  NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

  
--
  To post to this group, send email to excel-macros@googlegroups.com




-- 
Shrini
-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com