Dear Ravinder,
I have learnt lot from you. you have help me before.
this time you have give awesome formulas for mobile and email column.
just one query DOB Column don't accepts any date format, I have entered
30-09-1986 or 09/30/1986 format but not accepted, am I doing something
wrong
On
please check attachment its allowing to input only DD/MM/ or DD-MM/,
if still you face problem then change DOB column in Text format from General
or date
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rupesh Patil
Sent: Friday, March 14, 2014
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
controlhttp://www.kettic.com/winforms_ui/commandbar_overview.shtmland UI
dropdown list controlhttp://www.kettic.com/winforms_ui/dropdown_list.shtmlbe
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,
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 ravindervbacli...@gmail.com wrote:
Pfa. if not receive...
*From:* excel-macros@googlegroups.com [mailto:
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:
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 =
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
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
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 =
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
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
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.
Test mail Please ignore
Thanks regards,
www.MrExcel4U.com http://mrexcel4u.blogspot.com/
On Thu, Mar 6, 2014 at 5:20 PM, Caroline Campos caroline@gmail.comwrote:
I have two worksheets and I linked the cells to change automatically, but
when I insert a hyperlink in the cell of the
14 matches
Mail list logo