Re: $$Excel-Macros$$ How to link a cell between two worksheets keeping the Hyperlink?

[mrExcel4u]

Test mail Please ignore

Thanks & regards,

www.MrExcel4U.com 


On Thu, Mar 6, 2014 at 5:20 PM, Caroline Campos wrote:

> I have two worksheets and I linked the cells to change automatically, but
> when I insert a hyperlink in the cell of the original worksheet, it does
> not change the other worksheet that should be updated.
> Copying and pasting the cells, it works, but when i update the hiperlink,
> it doesn't
> So, I need too link the cells, and when updating, change the hiperlink too.
> Somebody help me? Thank you.
>
> --
> 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/d/optout.

$$Excel-Macros$$ Save an Excel file as XML

[Eugene Bernard]

How to save an excel table data in XML format.

TIA.
Eugene

-- 
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/d/optout.

$$Excel-Macros$$ formatar colunas com especificidade melhor

[Carlos Antonio]

Olá.

Na planilha que estou melhorando há os seguintes campos: cpf, nome, email E 
nomebreve.

Necessito o seguinte;

1 - cpf : somente seus números e quantidade de 11, nem mais nem menos, 11 
dígitos numéricos;
2 - nome : somente letras;
3 - email : máscara para E-mail, algo como (*@*provedor.com);
4 - nomebreve : com até 15 caracteres.

Agradeço.

Carlos.

-- 
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/d/optout.

$$Excel-Macros$$ Re: additional row creation

[E J]

Thanks, Ravinder! I really appreciate it!



On Thursday, March 13, 2014 3:33:25 PM UTC-7, E J wrote:
>
> Hi Everyone,
>
> I was wondering if I could get help with a macro. I'm trying to write a 
> macro (with no luck) that walks down a column based on the initial 
> placement of the active cell. Every time there are two cells with different 
> data it adds two (or N rows).  It doesn't, however, view  blank cells as 
> piece of data.
>
> I've attached an example of what a before and after would look like. Any 
> help would be greatly appreciated.
>
> Sincerely
>
> -Ej
>
>
>

-- 
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/d/optout.

Re: $$Excel-Macros$$ additional row creation

[E J]

Thanks, Vikas. Wow. This is great! I sincerely appreciate it.

On Thursday, March 13, 2014 10:18:44 PM UTC-7, Vikas Verma wrote:
>
> Hi E J  try this... 
>
>
> Sub testing()
>
> Dim rng As Range
> Dim rcount As Long
> Dim cel As Range
>
> rcount = Sheets(1).Cells(Rows.Count, "c").End(xlUp).Row
> Set rng = Sheets(1).Range("c1:c" & rcount)
> 
> For Each cel In rng
> If cel <> cel.Offset(1, 0) And cel <> "" Then
> cel.Offset(1, 0).Select
> ActiveCell.EntireRow.Insert
> End If
> Next cel
>
> End Sub
>
>
> Thanks & regards,
>
> www.MrExcel4U.com 
>
>
> On Fri, Mar 14, 2014 at 4:03 AM, E J >wrote:
>
>> Hi Everyone,
>>
>> I was wondering if I could get help with a macro. I'm trying to write a 
>> macro (with no luck) that walks down a column based on the initial 
>> placement of the active cell. Every time there are two cells with different 
>> data it adds two (or N rows).  It doesn't, however, view  blank cells as 
>> piece of data.
>>
>> I've attached an example of what a before and after would look like. Any 
>> help would be greatly appreciated.
>>
>> Sincerely
>>
>> -Ej
>>
>>
>>  -- 
>> 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/d/optout.
>>
>
>

-- 
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/d/optout.

Re: $$Excel-Macros$$ Dynamic Attachment with Email Send

[Vijay]

Dear Mr. Richard,

Thanks for the reply. im really happy for received E Mail from you for what
i'm expected and i have few more requirement to fulfill the process what i
exactly need as mentioned below.

1. I want to send it through MS Outlook instead of Gmail.
2. Not Require a Command Button in Excel, its enough in normal Excel macro.
3. in this excel sheet it shows command button and drop down button. but i
do not require a Command & drop down to select and split the branch name
instead of that if i required for particular branch name, it should be
automatically filtered and be attached to the E Mail.

and i also attached example Branch Split Macro for your ready reference.

Regards,
Vijay
+919940408060


On Fri, Mar 14, 2014 at 8:35 AM, Ricardo(R)  wrote:

> Hi Vijay,
>
> Follows this example, see if it meets your need .
>
> Rgds.
>
> Basole.
>
>
>
> 2014-03-13 15:23 GMT-03:00 Vijay :
>
>> Hi Team,
>>
>> I need a help in creating a macro for attached Excel File in E Mail.
>>
>> Process Brief:-
>> 1) I have one excel file. In that excel file, there is one column named
>> as "Branch Name". Which is important us to find out Branch Name and that
>> particular
>> branch details should be create as Separate file.
>> 2) Once separate file has been created, Excel file name should be saved
>> as Branch name after which
>> is created that the particular sheet automatically attached to E mail "TO
>> and "CC" should assigned as per particulars available in the E mail column
>> in that excel sheet.
>> and if other branch file name to be sent as attachement in E Mail, it is
>> only to send as per the E Mail column details. Example if TO and/or CC
>> column kept as blank. Macro should not send to the same. and also E Mail
>> should not repeat.
>> As mentioned above steps, Suppose i need another branch name, after
>> created as branch file name and attached if i want to send E Mail (as
>> applicable in that column, irrespective of "TO" and "CC")
>> it should e mail as per particulars available in that column.
>> 3) I should be able to give the path where the files are stored. The file
>> would in .xls format.
>>
>> Thanking you in advance.
>>
>> Regards
>> Vijay
>>
>> --
>> 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/d/optout.
>>
>
>  --
> 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 a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/kY0OikQHSMo/unsubscribe.
> To unsubscribe from this group and all its topics, 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/d/optout.
>

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

Re: FW: $$Excel-Macros$$ Conditional Formating

[Prafull Jadhav]

Dear Sir,

Once i select that cell then i will apply condition formatting selected
cell.
that's why i want to know the selection of that cells which having %
formatting.

Initially, I was doing same by using F5-Selection-Formula and then applied
condition formatting.
but this times other formulas also there in sheet that's why I am not able
to apply the condition formatting.






Regards,
Prafull Jadhav
9920553518


On 14 March 2014 15:47, Ravinder  wrote:

> What you want to do with that selection.color them or else
>
>
>
> Below is code to color % format cell
>
>
>
> Sub Button1_Click()
>
> Dim ws As Worksheet
>
> Dim cell As Range
>
> Set ws = ThisWorkbook.ActiveSheet
>
>
>
> For Each cell In ws.UsedRange
>
> If cell.NumberFormat = "0.00%" Then
>
> cell.Interior.Color = vbGreen
>
> End If
>
>
>
>
>
> Next
>
>
>
> End Sub
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Prafull Jadhav
> *Sent:* Friday, March 14, 2014 3:36 PM
> *To:* excel-macros@googlegroups.com
>
> *Subject:* Re: FW: $$Excel-Macros$$ Conditional Formating
>
>
>
> Dear Sir,
>
>
>
> I want a VBA code ;which will select the all cell in sheet where cell
> format is "0.00%"
>
>
>
>
> Regards,
> Prafull Jadhav
> 9920553518
>
>
>
> On 14 March 2014 15:31, Ravinder  wrote:
>
> You just select the whole range of tables and put condition formatting as
> already applied on $A$1:$L$21, you can increase as per your requirement.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Prafull Jadhav
> *Sent:* Friday, March 14, 2014 3:29 PM
> *To:* excel-macros@googlegroups.com
> *Cc:* Soum
> *Subject:* Re: FW: $$Excel-Macros$$ Conditional Formating
>
>
>
> Dear Sir,
>
>
>
> It is not working..
>
>
>
> Please let me know how I can select the all cell in sheet where cell
> format is "%"
>
>
>
>
>
>
> Regards,
> Prafull Jadhav
> 9920553518
>
>
>
> On 14 March 2014 15:12, Ravinder  wrote:
>
> Pfa. if not receive...
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ravinder
> *Sent:* Friday, March 14, 2014 3:08 PM
> *To:* excel-macros@googlegroups.com
> *Cc:* 'excelvbacli...@googlegroups.com'; Soum
> *Subject:* FW: $$Excel-Macros$$ Conditional Formating
>
>
>
> Did you not receive this file..
>
>
>
> *From:* Ravinder 
> [mailto:ravinderexcelgr...@gmail.com]
>
> *Sent:* Friday, March 14, 2014 2:31 PM
> *To:* 'excel-macros@googlegroups.com';
> *Cc:* Soum (quote.ex...@gmail.com)
> *Subject:* RE: $$Excel-Macros$$ Conditional Formating
>
>
>
> Pfa.. may be help you
>
>
>
> *From:* excel-macros@googlegroups.com [
> mailto:excel-macros@googlegroups.com ] *On
> Behalf Of *Prafull Jadhav
> *Sent:* Friday, March 14, 2014 1:25 PM
> *To:* excelvbacli...@googlegroups.com; excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Conditional Formating
>
>
>
> Dear All,
>
> Very Good Afternoon,
>
> I have a small query.
>
>
>
> I have many table in a sheet which contain formula.
>
> I want to apply conditional formatting based on Percentage (Colour Scales)
>
>
>
> I am not able to select the cell where cell value format is Percentage .
>
>
>
> Kindly help me and also explain  the simple way
>
> I have attached the sample for the same.
>
>
>
> Regards,
> Prafull Jadhav
> 9920553518
>
> --
> 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/d/optout.
>
> --
> 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 

RE: FW: $$Excel-Macros$$ Conditional Formating

[Ravinder]

What you want to do with that selection...color them or else

 

Below is code to color % format cell

 

Sub Button1_Click()

Dim ws As Worksheet

Dim cell As Range

Set ws = ThisWorkbook.ActiveSheet

 

For Each cell In ws.UsedRange

If cell.NumberFormat = "0.00%" Then

cell.Interior.Color = vbGreen

End If

 

 

Next

 

End Sub

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Friday, March 14, 2014 3:36 PM
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ Conditional Formating

 

Dear Sir,

 

I want a VBA code ;which will select the all cell in sheet where cell format
is "0.00%"

 




Regards,
Prafull Jadhav
9920553518

 

On 14 March 2014 15:31, Ravinder  wrote:

You just select the whole range of tables and put condition formatting as
already applied on $A$1:$L$21, you can increase as per your requirement.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Friday, March 14, 2014 3:29 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: Re: FW: $$Excel-Macros$$ Conditional Formating

 

Dear Sir,

 

It is not working..

 

Please let me know how I can select the all cell in sheet where cell format
is "%"

 

 




Regards,
Prafull Jadhav
9920553518

 

On 14 March 2014 15:12, Ravinder  wrote:

Pfa. if not receive.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Friday, March 14, 2014 3:08 PM
To: excel-macros@googlegroups.com
Cc: 'excelvbacli...@googlegroups.com'; Soum
Subject: FW: $$Excel-Macros$$ Conditional Formating

 

Did you not receive this file..

 

From: Ravinder [mailto:ravinderexcelgr...@gmail.com] 
Sent: Friday, March 14, 2014 2:31 PM
To: 'excel-macros@googlegroups.com';   
Cc: Soum (quote.ex...@gmail.com)
Subject: RE: $$Excel-Macros$$ Conditional Formating

 

Pfa.. may be help you..

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Friday, March 14, 2014 1:25 PM
To: excelvbacli...@googlegroups.com; excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Conditional Formating

 

Dear All,

Very Good Afternoon,

I have a small query.

 

I have many table in a sheet which contain formula.

I want to apply conditional formatting based on Percentage (Colour Scales)

 

I am not able to select the cell where cell value format is Percentage .

 

Kindly help me and also explain  the simple way 

I have attached the sample for the same.

 

Regards,
Prafull Jadhav
9920553518

-- 
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/d/optout.

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

Re: FW: $$Excel-Macros$$ Conditional Formating

[Prafull Jadhav]

Dear Sir,

I want a VBA code ;which will select the all cell in sheet where cell
format is "0.00%"


Regards,
Prafull Jadhav
9920553518


On 14 March 2014 15:31, Ravinder  wrote:

> You just select the whole range of tables and put condition formatting as
> already applied on $A$1:$L$21, you can increase as per your requirement.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Prafull Jadhav
> *Sent:* Friday, March 14, 2014 3:29 PM
> *To:* excel-macros@googlegroups.com
> *Cc:* Soum
> *Subject:* Re: FW: $$Excel-Macros$$ Conditional Formating
>
>
>
> Dear Sir,
>
>
>
> It is not working..
>
>
>
> Please let me know how I can select the all cell in sheet where cell
> format is "%"
>
>
>
>
>
>
> Regards,
> Prafull Jadhav
> 9920553518
>
>
>
> On 14 March 2014 15:12, Ravinder  wrote:
>
> Pfa. if not receive...
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ravinder
> *Sent:* Friday, March 14, 2014 3:08 PM
> *To:* excel-macros@googlegroups.com
> *Cc:* 'excelvbacli...@googlegroups.com'; Soum
> *Subject:* FW: $$Excel-Macros$$ Conditional Formating
>
>
>
> Did you not receive this file..
>
>
>
> *From:* Ravinder 
> [mailto:ravinderexcelgr...@gmail.com]
>
> *Sent:* Friday, March 14, 2014 2:31 PM
> *To:* 'excel-macros@googlegroups.com';
> *Cc:* Soum (quote.ex...@gmail.com)
> *Subject:* RE: $$Excel-Macros$$ Conditional Formating
>
>
>
> Pfa.. may be help you
>
>
>
> *From:* excel-macros@googlegroups.com [
> mailto:excel-macros@googlegroups.com ] *On
> Behalf Of *Prafull Jadhav
> *Sent:* Friday, March 14, 2014 1:25 PM
> *To:* excelvbacli...@googlegroups.com; excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Conditional Formating
>
>
>
> Dear All,
>
> Very Good Afternoon,
>
> I have a small query.
>
>
>
> I have many table in a sheet which contain formula.
>
> I want to apply conditional formatting based on Percentage (Colour Scales)
>
>
>
> I am not able to select the cell where cell value format is Percentage .
>
>
>
> Kindly help me and also explain  the simple way
>
> I have attached the sample for the same.
>
>
>
> Regards,
> Prafull Jadhav
> 9920553518
>
> --
> 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/d/optout.
>
> --
> 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/d/optout.
>
> --
> 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 

RE: FW: $$Excel-Macros$$ Conditional Formating

[Ravinder]

You just select the whole range of tables and put condition formatting as
already applied on $A$1:$L$21, you can increase as per your requirement.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Friday, March 14, 2014 3:29 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: Re: FW: $$Excel-Macros$$ Conditional Formating

 

Dear Sir,

 

It is not working..

 

Please let me know how I can select the all cell in sheet where cell format
is "%"

 

 




Regards,
Prafull Jadhav
9920553518

 

On 14 March 2014 15:12, Ravinder  wrote:

Pfa. if not receive.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Friday, March 14, 2014 3:08 PM
To: excel-macros@googlegroups.com
Cc: 'excelvbacli...@googlegroups.com'; Soum
Subject: FW: $$Excel-Macros$$ Conditional Formating

 

Did you not receive this file..

 

From: Ravinder [mailto:ravinderexcelgr...@gmail.com] 
Sent: Friday, March 14, 2014 2:31 PM
To: 'excel-macros@googlegroups.com';   
Cc: Soum (quote.ex...@gmail.com)
Subject: RE: $$Excel-Macros$$ Conditional Formating

 

Pfa.. may be help you..

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Friday, March 14, 2014 1:25 PM
To: excelvbacli...@googlegroups.com; excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Conditional Formating

 

Dear All,

Very Good Afternoon,

I have a small query.

 

I have many table in a sheet which contain formula.

I want to apply conditional formatting based on Percentage (Colour Scales)

 

I am not able to select the cell where cell value format is Percentage .

 

Kindly help me and also explain  the simple way 

I have attached the sample for the same.

 

Regards,
Prafull Jadhav
9920553518

-- 
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/d/optout.

-- 
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/d/optout.

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

Re: FW: $$Excel-Macros$$ Conditional Formating

[Prafull Jadhav]

Dear Sir,

It is not working..

Please let me know how I can select the all cell in sheet where cell format
is "%"



Regards,
Prafull Jadhav
9920553518


On 14 March 2014 15:12, Ravinder  wrote:

> Pfa. if not receive...
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Ravinder
> *Sent:* Friday, March 14, 2014 3:08 PM
> *To:* excel-macros@googlegroups.com
> *Cc:* 'excelvbacli...@googlegroups.com'; Soum
> *Subject:* FW: $$Excel-Macros$$ Conditional Formating
>
>
>
> Did you not receive this file..
>
>
>
> *From:* Ravinder 
> [mailto:ravinderexcelgr...@gmail.com]
>
> *Sent:* Friday, March 14, 2014 2:31 PM
> *To:* 'excel-macros@googlegroups.com';
> *Cc:* Soum (quote.ex...@gmail.com)
> *Subject:* RE: $$Excel-Macros$$ Conditional Formating
>
>
>
> Pfa.. may be help you
>
>
>
> *From:* excel-macros@googlegroups.com [
> mailto:excel-macros@googlegroups.com ] *On
> Behalf Of *Prafull Jadhav
> *Sent:* Friday, March 14, 2014 1:25 PM
> *To:* excelvbacli...@googlegroups.com; excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Conditional Formating
>
>
>
> Dear All,
>
> Very Good Afternoon,
>
> I have a small query.
>
>
>
> I have many table in a sheet which contain formula.
>
> I want to apply conditional formatting based on Percentage (Colour Scales)
>
>
>
> I am not able to select the cell where cell value format is Percentage .
>
>
>
> Kindly help me and also explain  the simple way
>
> I have attached the sample for the same.
>
>
>
> Regards,
> Prafull Jadhav
> 9920553518
>
> --
> 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/d/optout.
>
> --
> 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/d/optout.
>
> --
> 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 s

$$Excel-Macros$$ Differenent text returns using Cell("format" address) formula in excel.

[Ravinder]

Screen Clipping

-- 
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/d/optout.
<>

$$Excel-Macros$$ Re: commandbar dropdown menu to count worksheets

[Miachael Annie]

That's really not an easy problem. I didn't figure out where did you do 
wrong in your codes. Don't know if some thing like the UI commandbar 
controland UI 
dropdown list controlbe 
helpful here or not.

-- 
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/d/optout.