Re: $$Excel-Macros$$ Using Excel macro to type custom function in cell ...

2012-10-11 Thread David Grugeon 
ActiveSheet'cells(2,"AP").formula =" =Switch2(Y2,""B"",
AH2,""H"",NOT(AH2),""O"")"
Regards
David Grugeon


On 11 October 2012 14:40, Greg  wrote:
> Hi,
>
> Can you help me write a macro that will type a custom function I created
> into a cell? For example, I want the macro to type the following function:
>
> =Switch2(Y2,"B", AH2,"H",NOT(AH2),"O")
>
> inside cell AP2
>
> Thanks in advance for your help.
>
> Greg
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Re: Using Excel macro to type custom function in cell ...

2012-10-11 Thread Prince 
Hi Gerg

Just copy paste this macro and run it.

sub test()
  with ActiveSheet
.range("AP2").Formula= "=Switch(Y2,""B"",""H"",NOT(AH2),""O"")"
  end with
end sub

Regards


On Thursday, October 11, 2012 10:10:21 AM UTC+5:30, Greg wrote:
>
> Hi,
>
> Can you help me write a macro that will type a custom function I created 
> into a cell? For example, I want the macro to type the following function:
>
> =Switch2(Y2,"B", AH2,"H",NOT(AH2),"O")
>
> inside cell AP2
>
> Thanks in advance for your help.
>
> Greg
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ compare and highlight

2012-10-11 Thread NOORAIN ANSARI 
Dear Pavan,

Please try it..


Function compare(rng As Range, rng1 As Range)
Dim i As Integer
rng.Font.Color = vbBlack
rng1.Font.Color = vbBlack
For i = 1 To VBA.Len(rng)
If VBA.Mid(rng, i, 1) <> VBA.Mid(rng1, i, 1) Then
rng.Characters(i, 1).Font.Color = vbRed
rng1.Characters(i, 1).Font.Color = vbRed
End If
Next
compare = ""
End Function

http://www.excelvbaclinic.com/2012/10/compare-and-highlight-cell-udf.html

On Wed, Oct 10, 2012 at 1:52 PM, pavan Kumar  wrote:

> Hi Team,
>
> I am looking for macro to compare and highlight,i have given the example
> below
>
> two words has been compared
>
> hello and hella
>
> i need" o "and" a" to be higlighted in red
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Should Highlighted formula cell & reference cell also

2012-10-11 Thread Rakesh Kumar Sharma 
Dear,

Pls Find the Excel file as a sample



On Thu, Oct 11, 2012 at 5:39 PM, Rakesh Kumar Sharma  wrote:

> Dear Experts,
>
>
> Pls resolve this query.
> when we use any formula and press F2 then it goes highlighted and
> reference cells also. i want when i only select the formula cell it should
> go highlighted.. See the attachment.
>
>
>
> --
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-9971024741
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




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

RE: $$Excel-Macros$$ Fun with Chart

2012-10-11 Thread Rajan_Verma 
Send any picture of that

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Amit Desai (MERU)
Sent: 11 October 2012 9:15
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Fun with Chart

 

Dear Noorain/Rajan,

 

This too was really nice

 

Can you or someone create a Meditation Chakra? That could be use for Meditation 
on Full screen! 

 

I am this will not be difficult for you masters...Also please share how did you 
prepared this Owe some creative graphics..

 

Best Regards,

Amit

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of NOORAIN ANSARI
Sent: 10 October 2012 23:43
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Fun with Chart

 

One more addition...in Rajan's series

 

See attachment it is also more funny..

On Wed, Oct 10, 2012 at 10:05 PM, Mangesh Vimay  wrote:

Awesome !!!

Aisa bhi hota hai Excel mein ...???

Surprise !!!


On 10/10/12, Ahmed Honest  wrote:
> Dear Rajan,
>
> Salute for your Support and Talent. Will it not be better to enlight us
> with your skills by having a list of topic to educate the group from that
> list one by one, so that we become more productive in our daily life work.
>
> For sure, I believe you too believe that Sharing Knowledge always expands
> and teaches you looot of experience...
>
> (My understanding is that someone like you should come up and do this
> initiative so that people expand and think beyond imagination to improve
> and for learners it will be a DAMN think out of box support).
>
> Think of this initiative if you can help us...
>
> Anyways, thanks again for your Support and Talent.
>
> Best Regars
> Ahmed Bawazir
>
>
> On Wed, Oct 10, 2012 at 7:16 PM, Rajan_Verma
> wrote:
>

>> * *
>>
>> *Just sharing fun with charts.*
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> ** **

>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ 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.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com 
>>  .
>>
>>
>>
>
>
>
> --
> Ahmed Bawazir

> *احمد باوزير*

>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com 
>  .
>
>
>


--

With regards,

*MaNgEsH*


--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 i

RE: $$Excel-Macros$$ Should Highlighted formula cell & reference cell also

2012-10-11 Thread Rajan_Verma 
Select Formula Cell and press Ctrl+ [ 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh Kumar Sharma
Sent: 11 October 2012 5:44
To: excel-macros@googlegroups.com; NOORAIN ANSARI
Subject: Re: $$Excel-Macros$$ Should Highlighted formula cell & reference
cell also

 

Dear,

Pls Find the Excel file as a sample 




On Thu, Oct 11, 2012 at 5:39 PM, Rakesh Kumar Sharma
 wrote:

Dear Experts,


Pls resolve this query.
when we use any formula and press F2 then it goes highlighted and reference
cells also. i want when i only select the formula cell it should go
highlighted.. See the attachment.



-- 

Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
 .
 
 




-- 

Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ VBA Code Related Question

2012-10-11 Thread amar takale 
Hi all Experts,
Can anybody tell me how to export worksheet with VBA code from one sheet to
another sheet.Suppose In my sheet if there are 5 tab & three VBA code
include.If I want to export one tab with VBA code to other new sheet it is
possible? I will try but not possible.
Pls suggest helpful guidance

Regards
Amar

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ VBA Code Related Question

2012-10-11 Thread Rajan_Verma 
When you move your worksheet.. your Code written in Worksheet Code window
will automatically move with it 

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 11 October 2012 6:14
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ VBA Code Related Question

 

Hi all Experts,
Can anybody tell me how to export worksheet with VBA code from one sheet to
another sheet.Suppose In my sheet if there are 5 tab & three VBA code
include.If I want to export one tab with VBA code to other new sheet it is
possible? I will try but not possible.
Pls suggest helpful guidance 

Regards
Amar

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ 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. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Should Highlighted formula cell & reference cell also

2012-10-11 Thread Rakesh Kumar Sharma 
Dear Rajan,

It is not working.
My concern is -  I want to see this when i move on cell to cell with Arrow
key it should be highlighted like image. As in image when i move to *19*
it should be highlighted & also reference cell.


On Thu, Oct 11, 2012 at 6:14 PM, Rajan_Verma wrote:

> *Select Formula Cell and press Ctrl+ [ *
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma
> *Sent:* 11 October 2012 5:44
> *To:* excel-macros@googlegroups.com; NOORAIN ANSARI
> *Subject:* Re: $$Excel-Macros$$ Should Highlighted formula cell &
> reference cell also
>
> ** **
>
> Dear,
>
> Pls Find the Excel file as a sample
>
>
> 
>
> On Thu, Oct 11, 2012 at 5:39 PM, Rakesh Kumar Sharma <
> rakeshks@gmail.com> wrote:
>
> Dear Experts,
>
>
> Pls resolve this query.
> when we use any formula and press F2 then it goes highlighted and
> reference cells also. i want when i only select the formula cell it should
> go highlighted.. See the attachment.
>
>
>
> -- 
>
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-9971024741
>
> ** **
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
>
>
>
> -- 
>
> Regards,
>
> Rakesh Kumar Sharma
> Contact: +91-9971024741
>
> ** **
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Regards,

Rakesh Kumar Sharma
Contact: +91-9971024741

-- 
Join official facebook

$$Excel-Macros$$ Re: Rajan Verma - Most Helpful Member September 2012

2012-10-11 Thread Shri 

Good Morning All,

I am new to this forum.  Need a macro code which may work as hot key like 
if we press Ctrl+1 and this macro can execute more than 4 actions. If is it 
possible. kindly advise. Also suggest from where can i ask these questions.

Warm Regards,
Shri Om


On Tuesday, October 2, 2012 6:34:33 PM UTC+3, Ayush Jain wrote:
>
> Dear members,
>  
> Rajan Verma has been selected as 'Most Helpful Member' for the month of 
> Sep'12. He has posted 137 posts in last month and helped forum members 
> through his excel expertise.
> I truly appreciate his knowledge, consistency and commitment to the group.
> *
> Rajan, please find enclosed the award certificate in honor of your 
> contribution. Congratulations and thanks for your contribution.
> *
>
> Thanks to Vabz, Don, Paul, Prince, Noorain, Kuldeep, David and all other 
> folks for helping excel enthusiasts voluntarily !! 
> Keep posting.
>  
> Regards,
> Ayush Jain
> Group Manager
>
> P.S. If you have any feedback, please share your thoughts by filling the 
> survey 
> form.
>  
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Re: Rajan Verma - Most Helpful Member September 2012

2012-10-11 Thread Rajan_Verma 

Your Query subject does not match with you query 

You can use 
APplication.OnKey "ShotCutKey","SubName"

to assign ShortCut key to any sub Procedure

Rajan.



On Friday, 12 October 2012 05:52:59 UTC+5:30, Shri wrote:
>
>
> Good Morning All,
>
> I am new to this forum.  Need a macro code which may work as hot key like 
> if we press Ctrl+1 and this macro can execute more than 4 actions. If is it 
> possible. kindly advise. Also suggest from where can i ask these questions.
>
> Warm Regards,
> Shri Om
>
>
> On Tuesday, October 2, 2012 6:34:33 PM UTC+3, Ayush Jain wrote:
>>
>> Dear members,
>>  
>> Rajan Verma has been selected as 'Most Helpful Member' for the month of 
>> Sep'12. He has posted 137 posts in last month and helped forum members 
>> through his excel expertise.
>> I truly appreciate his knowledge, consistency and commitment to the group.
>> *
>> Rajan, please find enclosed the award certificate in honor of your 
>> contribution. Congratulations and thanks for your contribution.
>> *
>>
>> Thanks to Vabz, Don, Paul, Prince, Noorain, Kuldeep, David and all other 
>> folks for helping excel enthusiasts voluntarily !! 
>> Keep posting.
>>  
>> Regards,
>> Ayush Jain
>> Group Manager
>>
>> P.S. If you have any feedback, please share your thoughts by filling the 
>> survey 
>> form.
>>  
>>
>>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ $$Excel-Macros$$ Need to find out date of latest data

2012-10-11 Thread Vijayendra Rao 
Dear Excel Learner,

Thanks for the solutions and  sorry for late response.

Can you please let me know the logic for 10^10  in below formula
=IF(COUNT($G6:$R6),LOOKUP(10^10,$G6:$R6,$G$5:$R$5),"")

Regards,
Vijayendra

2012/10/8 Ms-Exl-Learner 

>  Hi Vijayendra
>
> Copy and paste the below formula in AJ6 cell
>
> =IF(COUNT($G6:$R6),LOOKUP(10^10,$G6:$R6,$G$5:$R$5),"")
>
> Drag the AJ6 formula to the remaining cells of AJ Column.
>
> Refer the attachment file for details.
>
> Hope that helps!
>
> Let us know, in case of any further assistance.
>
> <><><><><><><>
> *Ms-Exl-Learner*
>
> <><><><><><><>
>
> On 08-10-2012 12:44 PM, Vijayendra Rao wrote:
>
> Dear All,
>
>
> I have some data which includes amount data. I need the latest data’s
> date. Request you to let me know what formula I can use it for the same.
>
> Excel file is attached with example.
>
>  Regards,
> Vijayendra
> 94491 67631
>
> ಧನ್ಯವಾದಗಳು,
> ವಿಜಯೇಂದ್ರ,
> ೯೪೪೯೧ ೬೭೬೩೧
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧

Regards,
Vijayendra
94491 67631

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.