Columns(1).Insert
With Range(b2, Range(b Rows.Count).End(xlUp)).Offset(, -1)
.Formula = =if(and(weekday(b2,2)weekday(b3,2),b3),1,)
.Value = .Value
On Error Resume Next
.SpecialCells(2, 1).Offset(0, 1).Delete Shift:=xlUp
.SpecialCells(2, 1).Offset(0,
Hi expert,
i have some problem in excel when i open new excel file then some problem
in header change and reflect like this
A B1
2
C 3
D 12345
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
On Thursday, October 3, 2013 11:01:36 PM UTC+8, ashish wrote:
check the attached file see if it helps
working. Thank you.
Plse teach me how to make 'Run macro' icon as per your attached
query.xlm
regard
Ray Ho
On Thu, Oct 3, 2013 at 8:24 PM, asd...@gmail.com javascript:
Dear Experts
Pls solution my critical formula issue in excel.I hope anyone help me to
resolve this issue.
Regards
Amar
--
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 @
have u selected r1c1 style
follow below steps to change it uncheck it
http://en.kioskea.net/faq/15308-excel-switch-to-r1c1-reference-style
On Fri, Oct 4, 2013 at 5:16 PM, Raj Kumar rajlu...@gmail.com wrote:
Hi expert,
i have some problem in excel when i open new excel file then some
Hi All,
Looking for some advice or comments. I have some code, that works well in
all versions of Excel prior to 2013. To simplify what it does let's just
say there is a worksheet with a button on it. When the user presses the
button a userform comes up. On that userform are some comboboxes
Hi,
Attached is the file with two examples.
I am looking for a similar output to be done using vba.
Let me know if you need any further clarification on this.
Thanks,
Joseph
On Wed, Oct 2, 2013 at 12:42 PM, ashish koul koul.ash...@gmail.com wrote:
please share the chart
On Wed, Oct 2,
*Wow! you are amazing met. :)*
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed. If you are not the intended recipient you are hereby
notified that any
Dear Friend,
i want to use total no of present or absent list using pivot table.
Please find the attachment.
--
Thanks £ Regards
Rakesh Kumar
+91-9650303464
--
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
Please find the attachment.
On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar rakesh.apt...@gmail.comwrote:
Dear Friend,
i want to use total no of present or absent list using pivot table.
Please find the attachment.
--
Thanks £ Regards
Rakesh Kumar
+91-9650303464
--
Thanks £
10 matches
Mail list logo