$$Excel-Macros$$ THANKs

2013-08-06 Thread SAJID MEMON 
Thankx a lot abhishek for your tipsI have complied more than 98% with your 
help. again i am sending a small 2% query for you help to complete my project.
Thankx againRegardsSajid memon  

From: abhishek@gmail.com
Date: Mon, 5 Aug 2013 15:12:48 +0530
Subject: Re: $$Excel-Macros$$ LEFT function Trouble !!! HELP PLZ !!!
To: excel-macros@googlegroups.com

I tried to understand your code but couldn't. However, see if the attached 
helps.
Thanks,

On Mon, Aug 5, 2013 at 2:56 PM, SAJID MEMON  wrote:





Dear I am making a small error in my file, only one condition is working in 
VBA, Please give me tips to complete it
Awaiting your answer
RegardsSajid Memon 

  





-- 

Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel



 

FORUM RULES

 

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) Jobs posting is not allowed.

6) Sharing copyrighted material and their links is not allowed.

 

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.

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

Visit this group at http://groups.google.com/group/excel-macros.

For more options, visit https://groups.google.com/groups/opt_out.

 

 







-- 

Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

 

FORUM RULES

 

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) Jobs posting is not allowed.

6) Sharing copyrighted material and their links is not allowed.

 

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.

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

Visit this group at http://groups.google.com/group/excel-macros.

For more options, visit https://groups.google.com/groups/opt_out.

 

 
  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Vlookup with Round - HELP REQUIRE ???

2013-08-06 Thread SAJID MEMON 
Dear experts,
I have attached a small query of rounding method in vlookup formulla, please 
guide me to complete my project. only 2% works is pending to complete my project
awaiting your response
RegardsSajid memon

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




ROUND METHOD.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ FW: Vlookup with Round - HELP REQUIRE ???

2013-08-06 Thread SAJID MEMON 







Dear experts,
I have attached a small query of rounding method in vlookup formulla, please 
guide me to complete my project. only 2% works is pending to complete my project
awaiting your response
RegardsSajid memon  
  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




ROUND METHOD.xls
Description: MS-Excel spreadsheet

Fwd: $$Excel-Macros$$ Vlookup with Round - HELP REQUIRE ???

2013-08-06 Thread Pravin Gunjal 
You can change as follows :-
=ROUND(VLOOKUP(F3:F1000,$I$3:$J$100,2,0)*(1+($J$1/100)),0)

Regards
Pravin Gunjal.

-- Forwarded message --
From: SAJID MEMON 
Date: Tue, Aug 6, 2013 at 2:10 PM
Subject: $$Excel-Macros$$ Vlookup with Round - HELP REQUIRE ???
To: Sundarvelan Natarajan 


Dear experts,

I have attached a small query of rounding method in vlookup formulla,
please guide me to complete my project. only 2% works is pending to
complete my project

awaiting your response

Regards
Sajid memon

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




ROUND METHOD.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ THANK YOU Pravin Gunjal with one last query

2013-08-06 Thread SAJID MEMON 
Dear expert,
Thanks to complete my project, can i use msgbox in negative queries like my 
attachment
RegardsSajid memon

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




New Microsoft Excel Worksheet.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ THANK YOU Pravin Gunjal with one last query

2013-08-06 Thread ravinder negi 


pfa..


 From: SAJID MEMON 
To: Sundarvelan Natarajan  
Sent: Tuesday, August 6, 2013 2:48 PM
Subject: $$Excel-Macros$$ THANK YOU Pravin Gunjal with one last query
 


 
Dear expert,

Thanks to complete my project, can i use msgbox in negative queries like my 
attachment

Regards
Sajid memon 
-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




calculate event.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Macro to delete row with specific phrase

2013-08-06 Thread De Premor 

Sub Button1_Click()
Dim Rng As Range, Str
Range("A1").Select
Do
For Each Str In Array("Friendly's", "Ruth's Chris Steak House", 
"Hooters", "Ruby Tuesday", "Chili's Grill & Bar")

If InStr(1, Selection, Str) > 0 Then Selection.EntireRow.Delete
Next
Selection.Offset(1, 0).Select
Loop Until Selection.Offset(0, 0) = ""
End Sub

Pada 06/08/2013 15:22, ravinder negi menulis:

"Friendly's"
"Ruth's Chris Steak House"
"Hooters"
"Ruby Tuesday"
"Chili's Grill & Bar"


--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Maintaining format when pasting data into a template

2013-08-06 Thread Steve Weaver 
Thank you Anoop for your suggestion. Since I am an accountant and was not 
involved in writing the code, would you be a little more specific and show 
me exactly where this code should be placed. 
 
Thank you again for your generous help.
 
Steve
 

On Thursday, August 1, 2013 10:30:45 PM UTC-4, Enrique Martin wrote:

> You can change your code line where there is copy criteria as given below
> Make sure to change sheet and range references accordingly
>
> Sheet2.Range("C24").Copy   
> Sheet2.Range("C25").PasteSpecial xlPasteValues, xlPasteSpecialOperationNone
>
>
> On Fri, Aug 2, 2013 at 6:01 AM, Steve Weaver 
> 
> > wrote:
>
>>
>>
>> I use the attached worksheet to copy specific data from the “InputData” 
>> tab into the appropriate “Rep 02, Rep 03, or Rep 05” tab. However, I do not 
>> want to change the format (e.g., column height or width, headings, etc.) as 
>> shown on the “Rep Template” tab. I simply want to paste the appropriate 
>> values using the existing macro.** 
>>
>> ** **
>>
>> Is it possible to modify the existing macro to accomplish this?
>>
>> ** **
>>
>> Thanks!
>>
>> ** **
>>
>> Steve
>>
>> ** **
>>  
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>
>
> -- 
> Regards,
> Anoop
> Sr. Developer
> Facebook ID - https://www.facebook.com/anooop.k.sharma
>  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Maintaining format when pasting data into a template

2013-08-06 Thread Steve Weaver 
Thank you Anoop for your suggestion. Since I am an accountant and was not 
involved in writing the code, would you be a little more specific and show 
me exactly where this code should be placed. 
 
Thank you again for your generous help.
 
Steve
 
 

On Thursday, August 1, 2013 8:31:42 PM UTC-4, Steve Weaver wrote:

>
>
> I use the attached worksheet to copy specific data from the “InputData” 
> tab into the appropriate “Rep 02, Rep 03, or Rep 05” tab. However, I do not 
> want to change the format (e.g., column height or width, headings, etc.) as 
> shown on the “Rep Template” tab. I simply want to paste the appropriate 
> values using the existing macro. 
>
>  
>
> Is it possible to modify the existing macro to accomplish this?
>
>  
>
> Thanks!
>
>  
>
> Steve
>
>  
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Text to number format while opening a file

2013-08-06 Thread Rajan sharma 
Dear experts,

i have a excel file which is extracted from a application as seen in
attached sample file. but the problem is that the numbers are in text
format, i want it to open as number format automatically, can be done like
that.




With warm regards,
Rajan Sharma

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




Function number.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Text to number format while opening a file

2013-08-06 Thread Rajan sharma 
experts, can it be possible as per my query ?




With warm regards,
Rajan Sharma



On Tue, Aug 6, 2013 at 5:41 PM, Rajan sharma wrote:

> Dear experts,
>
> i have a excel file which is extracted from a application as seen in
> attached sample file. but the problem is that the numbers are in text
> format, i want it to open as number format automatically, can be done like
> that.
>
>
>
>
> With warm regards,
> Rajan Sharma
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Re: Auto Filter

2013-08-06 Thread Bv Dileep 

On Thursday, 25 July 2013 04:48:54 UTC-5, Bv Dileep wrote: 
>
> Hello All,
>  
> Attached is the Autofilter Macro, Basis on the criteria it filtering the 
> data now i need to update as Yes in Colum H and rest all should be updated 
> as No.
>  
> Request you to update the Macro code accordingly.
>  
>  
> Thanks in Advance.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Text to number format while opening a file

2013-08-06 Thread ashish koul 
try this
Sub test()
Dim cl As Range

For Each cl In ActiveSheet.UsedRange
If cl.Value <> "" And (cl.Column = 5 Or cl.Column = 7) Then

cl.Value = cl.Value
End If



Next



End Sub



On Tue, Aug 6, 2013 at 6:02 PM, Rajan sharma wrote:

> experts, can it be possible as per my query ?
>
>
>
>
> With warm regards,
> Rajan Sharma
>
>
>
> On Tue, Aug 6, 2013 at 5:41 PM, Rajan sharma wrote:
>
>> Dear experts,
>>
>> i have a excel file which is extracted from a application as seen in
>> attached sample file. but the problem is that the numbers are in text
>> format, i want it to open as number format automatically, can be done like
>> that.
>>
>>
>>
>>
>> With warm regards,
>> Rajan Sharma
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*My Excel Blog *
Like Us on 
Facebook
Join Us on Facebook 


P Before printing, think about the environment.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Macro to delete row with specific phrase

2013-08-06 Thread Spencer Patterson 
Aside from the crazy windings text, that did the trick!  Thank you so much!

Is there a way to make is so that case does not matter? 

"Curves"
"curves"
"CURVES"

So they all get deleted?

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Macro Skipping Empty Cell with Data in rest of row

2013-08-06 Thread Geoff 
I made a sample file with hypothetical information since i can't give out 
real addresses and donation history.  In this example, i have 2 without a 
last name and it only skips the first one, again not sure why.  I've also 
attached the code i'm using to run the macro.  Thanks for the help!

On Monday, August 5, 2013 6:59:51 PM UTC-7, ashish wrote:
>
> Can u share a sample file 
>
>
> On Mon, Aug 5, 2013 at 10:50 PM, Geoff  >wrote:
>
>> Hi,
>>
>> I have a macro written that will check if a value in column X matches a 
>> specified value, if it does the row gets copied onto another tab and then 
>> the macro keeps looping to evaluate all the rows.  However, when cell A# is 
>> blank, but there's data in the rest of the cells in that row the macro will 
>> skip copying the row even though it has the specified value in the X column 
>> cell.  Not sure how to get around this, any help would be appreciated, 
>> thanks.
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>  
>>  
>>
>
>
>
> -- 
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *My Excel Blog *
> Like Us on 
> Facebook
> Join Us on Facebook 
>
>
> P Before printing, think about the environment.
>
>  
>  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




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


TY Code in Tabs.bas
Description: Binary data

Re: $$Excel-Macros$$ Macro Skipping Empty Cell with Data in rest of row

2013-08-06 Thread ashish koul 
hi Geff,


I have made few changes in the macro. Try this updated one see if it helps

Sub new_macros()
Dim wk As Worksheet
Dim shtnms
Dim i As Integer

Application.DisplayAlerts = False
shtnms = Array("T1 < 30", "T1 > 30", "T2 < 30", "T2 > 30", "TC", "TM", "TJ")

'del exisitng sheets except sheet1
For Each wk In ThisWorkbook.Sheets
If UCase(wk.Name) <> UCase("Sheet1") Then
wk.Delete
End If
Next



For i = LBound(shtnms) To UBound(shtnms)
Sheets.Add(after:=Sheets(Sheets.Count)).Name = shtnms(i)
Sheets("sheet1").Range("a1:z1").Copy
Destination:=ActiveSheet.Range("a1")
Next

' taken p assuming donation date will not be blank
For i = 2 To Sheets("sheet1").Range("p65356").End(xlUp).Row
Select Case UCase(Sheets("sheet1").Range("x" & i).Value)

Case "TC"
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("TC").Range("a" &
Sheets("TC").Range("p65356").End(xlUp).Row + 1)

Case "TM"
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("TM").Range("a" &
Sheets("TM").Range("p65356").End(xlUp).Row + 1)

Case "TJ"
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("TJ").Range("a" &
Sheets("TJ").Range("p65356").End(xlUp).Row + 1)

Case "T1"
If Sheets("sheet1").Range("Y" & i).Value <= 30 Then
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("T1 < 30").Range("a" & Sheets("T1 <
30").Range("p65356").End(xlUp).Row + 1)
Else
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("T1 > 30").Range("a" & Sheets("T1 >
30").Range("p65356").End(xlUp).Row + 1)
End If

Case "T2"
If Sheets("sheet1").Range("Y" & i).Value <= 30 Then
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("T2 < 30").Range("a" & Sheets("T2 <
30").Range("p65356").End(xlUp).Row + 1)
Else
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("T2 > 30").Range("a" & Sheets("T2 >
30").Range("p65356").End(xlUp).Row + 1)
End If


End Select

Next

Application.DisplayAlerts = True
' create new sheets


End Sub








On Tue, Aug 6, 2013 at 10:21 PM, Geoff  wrote:

> I made a sample file with hypothetical information since i can't give out
> real addresses and donation history.  In this example, i have 2 without a
> last name and it only skips the first one, again not sure why.  I've also
> attached the code i'm using to run the macro.  Thanks for the help!
>
>
> On Monday, August 5, 2013 6:59:51 PM UTC-7, ashish wrote:
>
>> Can u share a sample file
>>
>>
>> On Mon, Aug 5, 2013 at 10:50 PM, Geoff  wrote:
>>
>>> Hi,
>>>
>>> I have a macro written that will check if a value in column X matches a
>>> specified value, if it does the row gets copied onto another tab and then
>>> the macro keeps looping to evaluate all the rows.  However, when cell A# is
>>> blank, but there's data in the rest of the cells in that row the macro will
>>> skip copying the row even though it has the specified value in the X column
>>> cell.  Not sure how to get around this, any help would be appreciated,
>>> thanks.
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/**discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@**googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at 
>>> http://groups.google.com/**group/excel-macros
>>> .
>>> For more options, visit 
>>> https://groups.google.com/**groups/opt_out
>>> .
>>>
>>>
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>> *Visit*
>> *My Excel Blog *
>> Like Us on 
>> Facebook
>> Join Us on Facebook 
>>
>>
>> P Before printing, think about the environment.

Re: $$Excel-Macros$$ Macro Skipping Empty Cell with Data in rest of row

2013-08-06 Thread Geoff 
Wow! Thank you, much quicker and more elegant than my code.  One last 
question with it.  If i want both TY Code (column X) 'TC' and 'TJ' to map 
to the TC sheet, how would i change the code to do it?  I wasn't able to by 
adding  "or "TJ"" to the first Case "TC". or making a new case and adding 
it to the sheet.



On Tuesday, August 6, 2013 10:23:57 AM UTC-7, ashish wrote:
>
> hi Geff,
>
>
> I have made few changes in the macro. Try this updated one see if it helps
>
> Sub new_macros()
> Dim wk As Worksheet
> Dim shtnms
> Dim i As Integer
>
> Application.DisplayAlerts = False
> shtnms = Array("T1 < 30", "T1 > 30", "T2 < 30", "T2 > 30", "TC", "TM", 
> "TJ")
>
> 'del exisitng sheets except sheet1
> For Each wk In ThisWorkbook.Sheets
> If UCase(wk.Name) <> UCase("Sheet1") Then
> wk.Delete
> End If
> Next
>
>
>
> For i = LBound(shtnms) To UBound(shtnms)
> Sheets.Add(after:=Sheets(Sheets.Count)).Name = shtnms(i)
> Sheets("sheet1").Range("a1:z1").Copy 
> Destination:=ActiveSheet.Range("a1")
> Next
>
> ' taken p assuming donation date will not be blank
> For i = 2 To Sheets("sheet1").Range("p65356").End(xlUp).Row
> Select Case UCase(Sheets("sheet1").Range("x" & i).Value)
> 
>  Case "TC"
> Sheets("sheet1").Range("a" & i & ":z" & i).Copy 
> Destination:=Sheets("TC").Range("a" & 
> Sheets("TC").Range("p65356").End(xlUp).Row + 1)
> 
> Case "TM"
> Sheets("sheet1").Range("a" & i & ":z" & i).Copy 
> Destination:=Sheets("TM").Range("a" & 
> Sheets("TM").Range("p65356").End(xlUp).Row + 1)
>
> Case "TJ"
> Sheets("sheet1").Range("a" & i & ":z" & i).Copy 
> Destination:=Sheets("TJ").Range("a" & 
> Sheets("TJ").Range("p65356").End(xlUp).Row + 1)
> 
> Case "T1"
> If Sheets("sheet1").Range("Y" & i).Value <= 30 Then
> Sheets("sheet1").Range("a" & i & ":z" & i).Copy 
> Destination:=Sheets("T1 < 30").Range("a" & Sheets("T1 < 
> 30").Range("p65356").End(xlUp).Row + 1)
> Else
> Sheets("sheet1").Range("a" & i & ":z" & i).Copy 
> Destination:=Sheets("T1 > 30").Range("a" & Sheets("T1 > 
> 30").Range("p65356").End(xlUp).Row + 1)
> End If
> 
> Case "T2"
> If Sheets("sheet1").Range("Y" & i).Value <= 30 Then
> Sheets("sheet1").Range("a" & i & ":z" & i).Copy 
> Destination:=Sheets("T2 < 30").Range("a" & Sheets("T2 < 
> 30").Range("p65356").End(xlUp).Row + 1)
> Else
> Sheets("sheet1").Range("a" & i & ":z" & i).Copy 
> Destination:=Sheets("T2 > 30").Range("a" & Sheets("T2 > 
> 30").Range("p65356").End(xlUp).Row + 1)
> End If
> 
> 
>  End Select
>
> Next
>
> Application.DisplayAlerts = True
> ' create new sheets
>
>
> End Sub
>
>
>
>
>
>
>
>
> On Tue, Aug 6, 2013 at 10:21 PM, Geoff  >wrote:
>
>> I made a sample file with hypothetical information since i can't give out 
>> real addresses and donation history.  In this example, i have 2 without a 
>> last name and it only skips the first one, again not sure why.  I've also 
>> attached the code i'm using to run the macro.  Thanks for the help!
>>
>>
>> On Monday, August 5, 2013 6:59:51 PM UTC-7, ashish wrote:
>>
>>> Can u share a sample file 
>>>
>>>
>>> On Mon, Aug 5, 2013 at 10:50 PM, Geoff  wrote:
>>>
 Hi,

 I have a macro written that will check if a value in column X matches a 
 specified value, if it does the row gets copied onto another tab and then 
 the macro keeps looping to evaluate all the rows.  However, when cell A# 
 is 
 blank, but there's data in the rest of the cells in that row the macro 
 will 
 skip copying the row even though it has the specified value in the X 
 column 
 cell.  Not sure how to get around this, any help would be appreciated, 
 thanks.

 -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/**discussexcel
  
 FORUM RULES
  
 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send 
 an email to excel-macros...@**googlegroups.com.
 To post

Re: $$Excel-Macros$$ Macro Skipping Empty Cell with Data in rest of row

2013-08-06 Thread ashish koul 
try this

Sub new_macros()
Dim wk As Worksheet
Dim shtnms
Dim i As Integer

Application.DisplayAlerts = False
shtnms = Array("T1 < 30", "T1 > 30", "T2 < 30", "T2 > 30", "TC")

'del exisitng sheets except sheet1
For Each wk In ThisWorkbook.Sheets
If UCase(wk.Name) <> UCase("Sheet1") Then
wk.Delete
End If
Next



For i = LBound(shtnms) To UBound(shtnms)
Sheets.Add(after:=Sheets(Sheets.Count)).Name = shtnms(i)
Sheets("sheet1").Range("a1:z1").Copy
Destination:=ActiveSheet.Range("a1")
Next

' taken p assuming donation date will not be blank
For i = 2 To Sheets("sheet1").Range("p65356").End(xlUp).Row
Select Case UCase(Sheets("sheet1").Range("x" & i).Value)

Case "TC", "TJ", "TM"
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("TC").Range("a" &
Sheets("TC").Range("p65356").End(xlUp).Row + 1)


Case "T1"
If Sheets("sheet1").Range("Y" & i).Value <= 30 Then
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("T1 < 30").Range("a" & Sheets("T1 <
30").Range("p65356").End(xlUp).Row + 1)
Else
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("T1 > 30").Range("a" & Sheets("T1 >
30").Range("p65356").End(xlUp).Row + 1)
End If

Case "T2"
If Sheets("sheet1").Range("Y" & i).Value <= 30 Then
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("T2 < 30").Range("a" & Sheets("T2 <
30").Range("p65356").End(xlUp).Row + 1)
Else
Sheets("sheet1").Range("a" & i & ":z" & i).Copy
Destination:=Sheets("T2 > 30").Range("a" & Sheets("T2 >
30").Range("p65356").End(xlUp).Row + 1)
End If


End Select

Next

Application.DisplayAlerts = True
' create new sheets


End Sub




On Wed, Aug 7, 2013 at 2:47 AM, Geoff  wrote:

> Wow! Thank you, much quicker and more elegant than my code.  One last
> question with it.  If i want both TY Code (column X) 'TC' and 'TJ' to map
> to the TC sheet, how would i change the code to do it?  I wasn't able to by
> adding  "or "TJ"" to the first Case "TC". or making a new case and adding
> it to the sheet.
>
>
>
> On Tuesday, August 6, 2013 10:23:57 AM UTC-7, ashish wrote:
>
>> hi Geff,
>>
>>
>> I have made few changes in the macro. Try this updated one see if it helps
>>
>> Sub new_macros()
>> Dim wk As Worksheet
>> Dim shtnms
>> Dim i As Integer
>>
>> Application.DisplayAlerts = False
>> shtnms = Array("T1 < 30", "T1 > 30", "T2 < 30", "T2 > 30", "TC", "TM",
>> "TJ")
>>
>> 'del exisitng sheets except sheet1
>> For Each wk In ThisWorkbook.Sheets
>> If UCase(wk.Name) <> UCase("Sheet1") Then
>> wk.Delete
>> End If
>> Next
>>
>>
>>
>> For i = LBound(shtnms) To UBound(shtnms)
>> Sheets.Add(after:=Sheets(**Sheets.Count)).Name = shtnms(i)
>> Sheets("sheet1").Range("a1:z1"**).Copy Destination:=ActiveSheet.**
>> Range("a1")
>> Next
>>
>> ' taken p assuming donation date will not be blank
>> For i = 2 To Sheets("sheet1").Range("**p65356").End(xlUp).Row
>> Select Case UCase(Sheets("sheet1").Range("**x" & i).Value)
>>
>>  Case "TC"
>> Sheets("sheet1").Range("a" & i & ":z" & i).Copy
>> Destination:=Sheets("TC").**Range("a" & 
>> Sheets("TC").Range("p65356").**End(xlUp).Row
>> + 1)
>>
>> Case "TM"
>> Sheets("sheet1").Range("a" & i & ":z" & i).Copy
>> Destination:=Sheets("TM").**Range("a" & 
>> Sheets("TM").Range("p65356").**End(xlUp).Row
>> + 1)
>>
>> Case "TJ"
>> Sheets("sheet1").Range("a" & i & ":z" & i).Copy
>> Destination:=Sheets("TJ").**Range("a" & 
>> Sheets("TJ").Range("p65356").**End(xlUp).Row
>> + 1)
>>
>> Case "T1"
>> If Sheets("sheet1").Range("Y" & i).Value <= 30 Then
>> Sheets("sheet1").Range("a" & i & ":z" & i).Copy
>> Destination:=Sheets("T1 < 30").Range("a" & Sheets("T1 <
>> 30").Range("p65356").End(xlUp)**.Row + 1)
>> Else
>> Sheets("sheet1").Range("a" & i & ":z" & i).Copy
>> Destination:=Sheets("T1 > 30").Range("a" & Sheets("T1 >
>> 30").Range("p65356").End(xlUp)**.Row + 1)
>> End If
>>
>> Case "T2"
>> If Sheets("sheet1").Range("Y" & i).Value <= 30 Then
>> Sheets("sheet1").Range("a" & i & ":z" & i).Copy
>> Destination:=Sheets("T2 < 30").Range("a" & Sheets("T2 <
>> 30").Range("p65356").End(xlUp)**.Row + 1)
>> Else
>> Sheets("sheet1").Range("a" & i & ":z" & i).Copy
>> Destination:=Sheets("T2 > 30").Range("a" & Sheets("T2 >
>> 30").Range("p65356").End(xlUp)**.Row + 1)
>> End If
>>
>>
>>  End Select
>>
>> Next
>>
>> Application.DisplayAlerts = True
>> ' create new sheets
>>
>>
>> End Sub
>>
>>
>>
>>
>>
>>
>>
>>
>> On Tue, Aug 6, 2013 at 10:21 PM, Geoff  wrote:
>>
>>> I made a sample file with hypothetical information since i can't give
>>> out real addresses and donation history.  In this example, i have 2 without
>>> a last name and it only skips the first one, again not sure why.  I've also
>>> attached the code i'm using to run the macro.  Thanks f

Re: $$Excel-Macros$$ Macro to delete row with specific phrase

2013-08-06 Thread De Premor 

Try to change to Uppercase or Lowercase the test string and the sentences

In Ex:
If InStr(1, UCase(Selection), Ucase(Str)) > 0 Then 
Selection.EntireRow.Delete



Pada 06/08/2013 23:41, Spencer Patterson menulis:

Aside from the crazy windings text, that did the trick!  Thank you so much!

Is there a way to make is so that case does not matter?

"Curves"
"curves"
"CURVES"

So they all get deleted?



--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Text to number format while opening a file

2013-08-06 Thread Rajan sharma 
Dear Ashish sir,

  Thanks for the prompt reply. the code provided is not affecting the
format. Can you plse elaborate a bit more.





With warm regards,
Rajan Sharma



On Tue, Aug 6, 2013 at 8:23 PM, ashish koul  wrote:

> try this
> Sub test()
> Dim cl As Range
>
> For Each cl In ActiveSheet.UsedRange
> If cl.Value <> "" And (cl.Column = 5 Or cl.Column = 7) Then
>
> cl.Value = cl.Value
> End If
>
>
>
> Next
>
>
>
> End Sub
>
>
>
> On Tue, Aug 6, 2013 at 6:02 PM, Rajan sharma wrote:
>
>> experts, can it be possible as per my query ?
>>
>>
>>
>>
>> With warm regards,
>> Rajan Sharma
>>
>>
>>
>> On Tue, Aug 6, 2013 at 5:41 PM, Rajan sharma 
>> wrote:
>>
>>> Dear experts,
>>>
>>> i have a excel file which is extracted from a application as seen in
>>> attached sample file. but the problem is that the numbers are in text
>>> format, i want it to open as number format automatically, can be done like
>>> that.
>>>
>>>
>>>
>>>
>>> With warm regards,
>>> Rajan Sharma
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *My Excel Blog *
> Like Us on 
> Facebook
> Join Us on Facebook 
>
>
> P Before printing, think about the environment.
>
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails

$$Excel-Macros$$ Help needed in Excel

2013-08-06 Thread Pankaj 


I have 2 columns in excel - A and B.

I want to merge the contents of a horizontal row one below the other as:
A
B

please tell me a formula to do this as the columns contain 900 cells each 
and I cannnot merge the contents manually using Alt + Enter.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ VBA code require

2013-08-06 Thread Prafull Jadhav 
Dear All,

Very Good Morning.

Please provide me VBA code as i am not able to write it .

Thanks in Advance.

Regards,
Prafull

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




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

Re: $$Excel-Macros$$ Macro to delete row with specific phrase

2013-08-06 Thread Spencer Patterson 
Thank you!

But I ran into one last problem with the code...

The amount of entries in the array string are too long, can I load a csv or 
text file to fill the array?  I have about 900 lines/phrases/items. 
It wont let me use that big of an array or too many line continuations. 

Help?  =)

On Tuesday, August 6, 2013 10:35:01 PM UTC-4, De Premor wrote:
>
>  Try to change to Uppercase or Lowercase the test string and the sentences
>
> In Ex:
> If InStr(1, UCase(Selection), Ucase(Str)) > 0 Then 
> Selection.EntireRow.Delete
>
>
>  Pada 06/08/2013 23:41, Spencer Patterson menulis:
>  
> Aside from the crazy windings text, that did the trick!  Thank you so much!
>
> Is there a way to make is so that case does not matter? 
>
> "Curves"
> "curves"
> "CURVES"
>
> So they all get deleted?
>
>
>  
>  

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Macro to delete row with specific phrase

2013-08-06 Thread De Premor 
Please give us a sample attachment that close to your probem, soo we can 
find the best method for it


Pada 07/08/2013 12:04, Spencer Patterson menulis:

Thank you!

But I ran into one last problem with the code...

The amount of entries in the array string are too long, can I load a 
csv or text file to fill the array?  I have about 900 
lines/phrases/items.

It wont let me use that big of an array or too many line continuations.

Help?  =)

On Tuesday, August 6, 2013 10:35:01 PM UTC-4, De Premor wrote:

Try to change to Uppercase or Lowercase the test string and the
sentences

In Ex:
If InStr(1, UCase(Selection), Ucase(Str)) > 0 Then
Selection.EntireRow.Delete


Pada 06/08/2013 23:41, Spencer Patterson menulis:

Aside from the crazy windings text, that did the trick!  Thank you so much!

Is there a way to make is so that case does not matter?

"Curves"
"curves"
"CURVES"

So they all get deleted?



--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send 
an email to excel-macros+unsubscr...@googlegroups.com.

To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Help needed in Excel

2013-08-06 Thread joseph camill 
Concatenate(a1,char(10),b1)
On Aug 7, 2013 9:24 AM, "Pankaj"  wrote:

>
>
> I have 2 columns in excel - A and B.
>
> I want to merge the contents of a horizontal row one below the other as:
> A
> B
>
> please tell me a formula to do this as the columns contain 900 cells each
> and I cannnot merge the contents manually using Alt + Enter.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.