Great Abhishek!.
Regards,
Prafull Jadhav
9920553518
On 8 September 2015 at 11:51, 'David Lanne' via MS EXCEL AND VBA MACROS <
excel-macros@googlegroups.com> wrote:
> Thank you very much
>
>
>
> On Tuesday, September 8, 2015 2:17 AM, Swapnil Palande <
> palande
Dear Ashish,
Great!
You have given explanation Step by Step.
Regards,
Prafull Jadhav
9920553518
On 5 December 2014 at 17:13, Ashish Kumar kumar.ashish...@gmail.com wrote:
Welcome Putta.
--
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
Dear Vaibhav Sir,
You are really Great. You have solution for all queries.
I am associate with this group since one year and learn lot of about VBA.
Sir...if you are conducting VBA courses then please enrolled my name first.
Keep it Sir.
Thanks once again!
Regards,
Prafull Jadhav
Dear Paul Sir,
Can you please explain what is
Debug.Assert True
Regards,
Prafull Jadhav
9920553518
On 22 November 2014 at 09:55, Mandeep Baluja rockerna...@gmail.com wrote:
Hello Paul,
First I would like to thank you from bottom of my *heart* for making such
an *efficient code* to handle
Dear Vaibhav Sir,
Thanks for the shared us a very useful file.
Regards,
Prafull Jadhav
9920553518
On 18 September 2014 17:32, Ganesh N ganeshg...@gmail.com wrote:
Got it sir!! Thanks
One more help sir. Like formulas do you have sample files for macros ?
just to learn. im a beginner
Dear Rupesh,
Have u open it with Enable Macro?
and also save it as it Macro Enable file...
Regards,
Prafull Jadhav
9920553518
On 8 September 2014 12:40, Rupesh Patil patil.rupesh1...@gmail.com wrote:
Hello Experts
I am using office 2013, when download any macro included workbook from
Dear Vaibhavji,
Great!
Regards,
Prafull Jadhav
9920553518
On 8 September 2014 12:55, Vaibhav Joshi v...@vabs.in wrote:
FA, It works upto 99 crore, you can modify to extend further.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Mon, Sep 8, 2014
Dear All,
Wish you very very happy Independence day.
Regards,
Prafull Jadhav
9920553518
On 14 August 2014 13:24, Vaibhav Joshi v...@vabs.in wrote:
Happy Independence Day!
--
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
find the same
Regards,
Prafull Jadhav
9920553518
On 8 August 2014 16:19, Mihai Ghilea mihai.ghi...@metabras.ro wrote:
Try this...
Mihai Ghilea
Network administrator
[image: Sigla_METABRAS_STEEL_PEOPLEmica]
ROMANIA
SC METABRAS SRL Brasov
Str. Grivitei A44, RO 500182
CUI
find the same...
Regards,
Prafull Jadhav
9920553518
On 8 August 2014 16:39, Prafull Jadhav prafulltjad...@gmail.com wrote:
find the same
Regards,
Prafull Jadhav
9920553518
On 8 August 2014 16:19, Mihai Ghilea mihai.ghi...@metabras.ro wrote:
Try this...
Mihai Ghilea
Network
!
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
Dear Ashish,
Thanks for Reply!
Actually I am not looking for the same.
I want to hyper link with only with one sheet .
Regards,
Prafull Jadhav
9920553518
On 5 August 2014 14:40, Ashish Kumar kumar.ashish...@gmail.com wrote:
Hi Prafull,
PFA.!!!
Regards
Ashish
On 5 August 2014 11
it but it is not blinking.
Please check my excel file.
Regards,
Prafull Jadhav
9920553518
On 5 August 2014 15:11, Ashish Kumar kumar.ashish...@gmail.com wrote:
Hi Prafull,
PFA...!!!
Regards
Ashish
On 5 August 2014 14:53, Prafull Jadhav prafulltjad...@gmail.com wrote:
Dear Ashish,
Thanks for Reply
Awesome!.Vaibhav Sir.
Thanks a Lot!
Regards,
Prafull Jadhav
9920553518
On 28 July 2014 12:28, Vaibhav Joshi v...@vabs.in wrote:
hi
you cont need such formula.. use this
formula =A1-MOD(A1,10)-A1-MOD(A1,10)+10
It is modeless whatever be the range yo have your answer!!
Cheers
Abhishek Sir,
Again you proved that you are Master..!
Regards,
Prafull Jadhav
9920553518
On 27 May 2014 16:21, Abhishek Jain abhishek@gmail.com wrote:
Happy to help :)
On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal isk1...@gmail.com wrote:
Dear Abhishek Jee,
It is really a very
Dear Abhishek Sir,
Great.
Regards,
Prafull Jadhav
9920553518
On 17 April 2014 12:09, Abhishek Jain abhishek@gmail.com wrote:
Dear Amar,
Please see the attached file. I hope this works for you.
You may login by using any of the following credentials (both username and
password
Dear All,
Good Afternoon!
I have a big data which is horizontal .. I have to put it vertically.
I am sending sample data ..Please help me 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
Dear Sir,
perfect !...
thanks a lot .
Regards,
Prafull Jadhav
9920553518
On 9 April 2014 16:11, Ravinder ravindervbacli...@gmail.com wrote:
PFA...first select range of heading as I have already selected in file.
*From:* excelvbacli...@googlegroups.com [mailto:
excelvbacli
Error status No Error ? C ? NC ?
Error --How to find out Quality- how to find out
Regards,
Prafull Jadhav
9920553518
On 17 March 2014 16:58, Prabhu Pinky prabhupin...@gmail.com wrote:
can you workout and send me..i did tried.. but am not getting result.
if you provide VBA code
Please check and ..let me know.
Regards,
Prafull Jadhav
9920553518
On 17 March 2014 21:12, Prafull Jadhav prafulltjad...@gmail.com wrote:
Error status No Error ? C ? NC ?
Error --How to find out Quality- how to find out
Regards,
Prafull Jadhav
9920553518
On 17 March 2014 16:58
...
It gives wrong Nos to Management.
Regards,
Prafull Jadhav
9920553518
On 15 March 2014 20:44, ravinder negi ravi_colw...@yahoo.com wrote:
pls provide some example in excel with chart
On Saturday, March 15, 2014 8:12 AM, Abhishek Jain
abhishek@gmail.com wrote:
Does this make any
Dear Abhishek Sir,
Very good morning.
If I now that ddaily frequency of cabs are between 50 to 80.
Because of suddenly increased in cabs for few days this affects the overall
average.
I just want to show normal average..
Which excluding few days highest cabs.
Regard,
Prafull Jadhav.
9920553518
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
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 ravinderexcelgr...@gmail.com wrote:
What you want to do with that selection.color them or else
Below is code to color % format cell
Dear All,
Waiting for the same.
Dear All,
Thanks for reply..
MY question is
when I use the Dynamic Range then output of Avg Response time is coming but
it is not applicable to Resolution.
Why this happen ..?
Please explain
Regards,
Prafull Jadhav
9920553518
On 12 March 2014 20:10
Dear All,
Thanks for reply..
MY question is
when I use the Dynamic Range then output of Avg Response time is coming but
it is not applicable to Resolution.
Why this happen ..?
Please explain
Regards,
Prafull Jadhav
9920553518
On 12 March 2014 17:58, Arvind mishra arvind44mis
Dear All,
Good Afternoon,
I want a examples of Dynamic Range of Pivot.
for example
if i added new data in master file then new rows or data should be added in
pivot or suppose i delete the data thane range should be adjust accordingly
Thanks in Advance.
Regards,
Prafull Jadhav
9920553518
,
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
Then*
*Selection.Offset(0, 12).Value = Hisar*
*ElseIf Selection.Offset(0, 2).Value = HSR-JMS(HR) Then*
*Selection.Offset(0, 12).Value = Hisar*
End If
Selection.Offset(1, 0).Select
Loop
Please help me in this regards.
Regards,
Prafull Jadhav
9920553518
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Thanks a lot Sir..
Perfect!
Regards,
Prafull Jadhav
9920553518
On 4 March 2014 17:21, Paul Schreiner schreiner_p...@att.net wrote:
You could replace your If/ElseIf/Endif statement with a Select Case
Statement:
Select Case Selection.Offset(0, 2).Value
Case GURGAON(DELHI-NCR
Dear Madam,
Very Good Morning
Thanks a lot for important and essential information about the hyperlink
for dynamic formula.
I have done it finally ...and it is working fine.
Thanks once again for explaining the whole topic step by step.
Regards,
Prafull Jadhav
9920553518
On 1 March 2014
Great Ravinder Sir..
Regards,
Prafull Jadhav
9920553518
On 28 February 2014 15:33, Ravinder ravinderexcelgr...@gmail.com wrote:
PFA.
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *amar takale
*Sent:* Friday, February 28, 2014 3:18 PM
Dear Madam,
I also trying the same but not able to understand the same.
It will be better if you explain the same...
Thanks in Advance ...Madam
Regards,
Prafull Jadhav
9920553518
On 28 February 2014 17:09, amar takale amartak...@gmail.com wrote:
Dear Raviderji Priti
Thank very much
validation.
I have created another file but i am unable to create the hyperlink for the
same sheet.
Thanks in Advance
Regards,
Prafull Jadhav
9920553518
On 28 February 2014 17:38, priti verma pritiverma1...@gmail.com wrote:
Hi Amar,
it is simple index match formula and 1 indicates row
Dear All,
Good After Noon,
I require one macro for attached excel sheet.
Appreciate cooperation expected from you.
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
Dear Ravinder Sir,
Thanks for Reply..it is working fine.
Can we make the same without selecting Range and paste range(Without
message box)?
Means we need not require fill the Range.
Regards,
Prafull Jadhav
9920553518
On 26 February 2014 16:59, Ravinder ravindervbacli...@gmail.com wrote
,Correct then next column(B1) should be
contain OK
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
automatically with each company and chart will update
accordingly .
Regards,
Prafull Jadhav
9920553518
On Wed, Dec 18, 2013 at 3:40 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
In Macro use conditional Formatting..use Top 10 option..
Regards,
*Amit Desai *– MIS Manager
M: +91
Dear All,
Very good morning and have great day.
Wating for output.
Regard,
Prafull Jadhav.
9920553518
Dear Prafull,
Let your Macro use the master file, get Top 10 list from Master from that
list you can just re-fresh the chart.
*From:* excel-macros@googlegroups.com [mailto:excel-macros
Dear Sir,
It is also not working ...
Value error is there .
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 25, 2013 at 1:43 PM, xlstime xlst...@gmail.com wrote:
you can try with --
formula like =--A3
.
Enjoy
Team XLS
On Mon, Nov 25, 2013 at 1:19 PM
Dear Sir,
Same is working on other PC
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 25, 2013 at 1:49 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Dear Sir,
It is also not working ...
Value error is there .
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 25, 2013 at 1:43 PM
Same error which is in my first attachmentsir
Regard,
Prafull Jadhav.
9920553518
On 25-Nov-2013 1:53 PM, xlstime xlst...@gmail.com wrote:
please share the snap shot
.
Enjoy
Team XLS
On Mon, Nov 25, 2013 at 1:50 PM, Prafull Jadhav
prafulltjad
Sir...same formula is working in other all friends pc...Only I m facing
same problem
Regard,
Prafull Jadhav.
9920553518
On 25-Nov-2013 2:18 PM, xlstime xlst...@gmail.com wrote:
yeah, but can u share the snap shot..
coz ur example sheet formula is working fine on my system
Sir, Can you tell me how to check and how modified
Regard,
Prafull Jadhav.
9920553518
On 25-Nov-2013 7:02 PM, Papnay, Ashish apap...@metlife.com wrote:
Hi Prafull,
What is the format of date in your system.
Like in my system the date formate is MM/DD/YY.
*Regards*
*Ashish
..Please let me know
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
Dear Sir,
It is not working .
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 18, 2013 at 3:40 PM, saurabh kumar
saurabhkumar8...@gmail.comwrote:
Hi Prafull,
Please find attached Check
Regards
Saurabh
On Mon, Nov 18, 2013 at 1:11 PM, Prafull Jadhav
prafulltjad...@gmail.comwrote
Sir thanks for reply.
But sir... For Only few rows not get corrected.. Rest things are
perfects...why this so.
Regard,
Prafull Jadhav.
9920553518
On 19-Nov-2013 12:03 AM, ashish koul koul.ash...@gmail.com wrote:
is it 1 apr 2013
try to change the setting of ur computer control panel
Hi Sir,
Thanks for Reply..
I have try this but result is coming wrong ...as out put showing jan and
Feb month also ..
data is contain from April to Nov ..
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 18, 2013 at 1:02 PM, saurabh kumar
saurabhkumar8...@gmail.comwrote:
Hi Prafull
DEAR RAJAN SIR,
thanks for reply...
but output showing jan and feb month also after running macro .
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 18, 2013 at 12:32 PM, Rajan sharma rajansharma9...@gmail.comwrote:
Hi, Try using below:
Sub prafu()
For Each x In Range(A1:A9000
Dear All,
Very Good Morning ..and Have a Great Day Ahead!
I got below Function from our group . I have modified it . We can put Space
between word
for example
PrafullJadhav then output is Prafull Jadhav
AjayNareshRane then output will be Ajay Naresh Rane
MY question is Can we create Macro
Dear All,
Thanks to Everybody...It is really working fine...
Regards,
Prafull Jadhav
9920553518
On Tue, Oct 29, 2013 at 10:11 AM, Prafull Jadhav
prafulltjad...@gmail.comwrote:
Dear All,
Very Good Morning ..and Have a Great Day Ahead!
I got below Function from our group . I have modified
Thanks a lot Sir,
Sir ..can you share one example for the same if possible.
*Regards,
Prafull Jadhav
9920553518*
On Thu, Oct 24, 2013 at 1:00 PM, xlstime xlst...@gmail.com wrote:
Value2 always uses the same value that Excel uses. It does not truncate
decimal places ,Value2 gives you
Got it !
Thanks a lot
Regard,
Prafull Jadhav.
9920553518
On 24-Oct-2013 1:37 PM, xlstime xlst...@gmail.com wrote:
sub rr()
range(a1).value =date
range(a2).value2=date
end sub
.
Enjoy
Team XLS
On Thu, Oct 24, 2013 at 1:31 PM, Prafull Jadhav
prafulltjad
Dear All ,
Very GooD Morning and Have a Great Day!
I have one query in VBA what is Value 2 . i know Value
When and Why Value 2 is use in VBA Code.
Appreciate cooperation expected from you
*Regards,
Prafull Jadhav
9920553518*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
Dear Ravinder Sir,
I want to know can we create function for the same.
*Regards,
Prafull Jadhav
9920553518*
On Mon, Sep 30, 2013 at 12:53 PM, Ravinder ravinderexcelgr...@gmail.comwrote:
For Each cell In Selection
With cell.Characters(Start:=3, Length:=1).Font
.Color
i have seen one function and i want to create the macro for the
same and i am not able to do this.
Function number(Text As String) For i = 1 To Len(Text) If
IsNumeric(Mid(Text, i, 1)) = True Then jo = jo Mid(Text, i, 1) End If Next
i number = jo End Function
*Regards,
Prafull Jadhav
Dear Ashish,
find the same with formula.
*Regards,
Prafull Jadhav
9920553518*
On Mon, Sep 23, 2013 at 1:39 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Anil,
Can you please help me to reslove this query through Excel formula.
Thanks,
Ashish
On Monday, September 23, 2013 12
Table Border
Line to each table First column alignment -left
*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
Dear Ashish Sir,
Thanks a lot.
Regards,
Prafull.
On Sat, Sep 14, 2013 at 8:59 AM, ashish koul koul.ash...@gmail.com wrote:
you can write udf to concatenate the range
On Fri, Sep 13, 2013 at 6:39 PM, Prafull Jadhav
prafulltjad...@gmail.comwrote:
Dear All,
Can we concatenate
Dear All,
Can we concatenate by using range with Arrey formula.?
for example
From Range(A2:K2) ..i have to concatenate.. but for this i have to put
formula
like concatenate(A2,B2,C2,D2...)
Can we do this by using Range.
concatenate(Range(A2:K2)
Regards,
Prafull Jadhav.
--
Are you
Dear Anil and Xlstime Sir,
can we use below method?
Sub prafull()
For Each x In Range(G2:G139)
If x.Font.Bold = True Then
x.Offset(0, 1).Value = 1
End If
Next x
End Sub
On Wed, Sep 11, 2013 at 2:23 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Ashish,
Pl see the attached
Dear All,
Very Good Morning
I have one Query .
i am looking in Range (A2:E2) . If cell contain yes word then don't
hide otherwise hide the column .
for example
if in A2 Cell word is Yes , i am Fine then A column must be hide
if D2 cell contain Prafull ,Yes is is fine then D column must be hide
, Prafull Jadhav wrote:
Dear All,
Very Good Morning
I have one Query .
i am looking in Range (A2:E2) . If cell contain yes word then don't
hide otherwise hide the column .
for example
if in A2 Cell word is Yes , i am Fine then A column must be hide
if D2 cell contain Prafull ,Yes
Remove* * from formula ...for number value
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi Team,
Request you to kindly provide me solution to below silly problem I am
facing in excel.
I am trying to get sum of data range B2 to B6 in cell B8. Answer which I
Dear Sir,
Plesae explain the for my information.
Range(a2:a15).Cells(K, 1) out would be like
ABDE.continue
but how it come
AABCCDDDEEFHHHIIJKLLMN
Please explain.
It working very fine as per my desire output
On Wed, Aug 28, 2013 at 10:53 AM, Prafull Jadhav
in row
and its hold range(a2:a15)'s value
.
Enjoy
Team XLS
On Thu, Aug 29, 2013 at 9:18 AM, Prafull Jadhav
prafulltjad...@gmail.comwrote:
Dear Sir,
Plesae explain the for my information.
Range(a2:a15).Cells(K, 1) out would be like
ABDE.continue
Dear All,
Very Good Morning ,
I have made macro but i am able to extract output in only one column but i
want it in 2 column .
Please help me in this regards,
Thanks in Advance.
Regards,
Prafull
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
On Wed, Aug 28, 2013 at 9:41 AM, Prafull Jadhav
prafulltjad...@gmail.comwrote:
Dear All,
Very Good Morning ,
I have made macro but i am able to extract output in only one column but
i want it in 2 column .
Please help me in this regards,
Thanks in Advance.
Regards,
Prafull
.TextRange.Font.Name = Arial
Selection.Format.TextFrame2.TextRange.Font.Size = 14
Next
End Sub
.
Enjoy
Team XLS
On Wed, Aug 21, 2013 at 10:34 AM, Prafull Jadhav prafulltjad...@gmail.com
wrote:
Dear All,
Very Good Morning,
I have made 10 charts and now
, Aug 21, 2013 at 2:25 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Thanks a lot Sir...It working Fine
On Wed, Aug 21, 2013 at 1:12 PM, xlstime xlst...@gmail.com wrote:
Try This
Sub Chart_Titles()
Dim ch As ChartObject
For Each ch In ActiveSheet.ChartObjects
ch.Activate
Dear All,
Very Good Morning,
I have made 10 charts and now I want to change the Size of Font 14 to 9
for Chart Title.
is it possible to change it through the VBA
for example
For each
For Next
Do until
if yes , Please provide the same
Thanks in Advance
Regards,
Prafull Jadhav
Dear Sajid,
if sum (D2 to 1000) is = B9 then what should be result.
in F column , in which cell you must have result.
Please see the attachment .
On Mon, Aug 12, 2013 at 11:28 AM, SAJID MEMON sajidwi...@hotmail.comwrote:
Dear Prafull Jadhav Ji,
My concept is different, I have list of amount
please let me know that
if sum (D2:D1000) is =B9 then output will display in F column only one
time
or
D2 to D3 is less then B9 then out put will come at F3
D2 to D4 is less then B9 then out put will come at F4
Regards,
Prafull Jadhav.
On Sun, Aug 11, 2013 at 5:49 PM, SAJID MEMON sajidwi
SAME TO YOU...Happy EID.
Please let me know ..Whole Range sum of D column is less then Cells B9 then
output will in F Column,.
Please check excel sheet .
Please let me know if any further changes .
Regards,
Prafull Jadhav.
On Sat, Aug 10, 2013 at 7:02 PM, SAJID MEMON sajidwi...@hotmail.com
Sub
Pada 09/08/2013 18:33, Prafull Jadhav menulis:
Dear Experts,
Can we have VBA code for the attached excel sheet.
Reg,
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
x In Range(A2:A10)
Range(B x.Row :D x.Row) = Split(Replace(Replace(Replace(x.Text,
Days , ), Hrs , ), Mins, ), )
Next
End Sub
Once again Thanks .
Regards,
Prafull Jadhav.
On Sat, Aug 10, 2013 at 6:29 AM, De Premor d...@premor.net wrote:
firstly, Str() as variant is an array that we need
Dear Sir,
Yes.You are Right ,Sir..
for preventing error you have added the minor code. I got it.
Finally i got my output ...Thanks a lot...
Have a Great Day ..
Regards,
Prafull Jadhav.
On Sat, Aug 10, 2013 at 7:35 AM, De Premor d...@premor.net wrote:
That is, you've almost done
Thanks a Sir lot.
Actually, i am learning the same .
I was able to write the code for single column but i didnot understand how
to write for second column
Regards,
Prafull Jadhav.
9920553518
On Wed, Aug 7, 2013 at 9:05 PM, ashish koul koul.ash...@gmail.com wrote:
Sub test()
For j = 1
Sir ,
Can we do this by using Macro
Sub prafull()
For Each x In Range(B2:B10)
x.Value = = x.Value
Next
End Sub
Regards,
Prafull
On Tue, Jul 30, 2013 at 12:31 PM, xlstime xlst...@gmail.com wrote:
if we have more then thousands of records than?
.
Enjoy
Team XLS
Dear Expert ,
I have made pivot ..I want to make it one Graph.
I am not able to make it in one Graph...
Can anyone can provide the same with attractive Graph.
Thanks in Advance.
Regards,
Prafull jadhav.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2
Dear Anil,
thanks for the same.
Actually I require one chart which contain all information .
Regards
Prafull Jadhav
On Fri, Jul 26, 2013 at 3:52 PM, Anil B ank.bira...@gmail.com wrote:
Hi Prafull,
Find attached the attractive chart as you requested.
Thanks,
Anil
On Fri, Jul 26, 2013
Dear Anil,
I have to preset the same in presentation...
I think i have to prepare the same with Different chart.
Thanks for the same.
Red,
Prafull Jadhav.
On Fri, Jul 26, 2013 at 4:26 PM, Anil B ank.bira...@gmail.com wrote:
Check it and let me know is it ok.
On Fri, Jul 26, 2013 at 4
at 4:47 PM, Prafull Jadhav
prafulltjad...@gmail.comwrote:
Dear Anil,
I have to preset the same in presentation...
I think i have to prepare the same with Different chart.
Thanks for the same.
Red,
Prafull Jadhav.
On Fri, Jul 26, 2013 at 4:26 PM, Anil B ank.bira...@gmail.com wrote
Dear Experts,
I have given password excel file but I have forget the password ..Is there
any way to recovery password.
Thanks in advance.
Regards,
Prafull Jadhav.
--
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
Dear Sir,
There is no any software for the same .
I cant send the file as it contain important information.
Regards,
Prafull
On Tue, Jul 23, 2013 at 2:37 PM, Ankit Mehra ankitmehr...@gmail.com wrote:
Hi Prafull,
Please send the file.
On Tue, Jul 23, 2013 at 11:30 AM, Prafull Jadhav
://www.excelpasswordrecovery.net/
http://www.elcomsoft.com/aopb.html
http://www.intelore.com/excel-password-recovery.php
There are also other software you can download from the internet.
Regards,
Vijaykumar
On Tue, Jul 23, 2013 at 3:28 PM, Prafull Jadhav
prafulltjad...@gmail.comwrote:
Dear Sir
Dear Expert ,
Can you expline the bold line as i want to know deeply.
Function Reverse(Text As String) As String
Dim i As Integer
Dim StrNew As String
Dim strOld As String
strOld = Trim(Text)
For i = 1 To Len(strOld)
* StrNew = Mid(strOld, i, 1) StrNew*
Next i
Dear Amit Sir,
you can do it by filter data.
1 go at end of row where data is end
then last row and select all till top (down to up)
2 filter on it
then you will get blank data ...you can remove it easy.
Regards,
prafull
9920553518
On Sat, Jul 20, 2013 at 6:02 PM, Amit Desai (MERU)
both are same.
in 2003 there was iferror and in 2007 it replaced by iserror.
On Thu, Jul 11, 2013 at 4:09 PM, Raj Kumar rajlu...@gmail.com wrote:
Hi Group,
Kindly let us know the difference between Iserror iferror in excel
Regards
Raj Bharti
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Dear Amar,
find the same with easy...by using mid function.
Regards
Prafull
On Wed, Jul 10, 2013 at 3:51 PM, Anil Kumar kumarmaury...@yahoo.com wrote:
--
*From:* amar takale amartak...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Tuesday, 4 September
Dear Murli,
Find the same
Regards,
Prafull Jadhav.
On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E emuralidha...@gmail.comwrote:
Dear friends,
Good afternoon,
I need a help and I want to know how to use vlookup function by using
match and columns function. How it is works?
Plz, share
result by using vlookup function?
Thanks in advance.
On 10 July 2013 16:34, Prafull Jadhav prafulltjad...@gmail.com wrote:
Dear Murli,
Find the same
Regards,
Prafull Jadhav.
On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E emuralidha...@gmail.comwrote:
Dear friends,
Good afternoon,
I
Dear Prabhakar,
find the same ...It is alternate use...
Our expert can give you better solution on it.
Regards,
Prafull Jadhav.
MIS-executive.
On Fri, Jul 5, 2013 at 11:27 AM, Prabhakar S H prabakar.k...@gmail.comwrote:
Hi Team,
I need your help to get details with formula in attached
Thanks Sir.
On Wed, Jul 3, 2013 at 10:52 AM, Vabs VBA v...@vabs.in wrote:
Hi
X refer to each cell in range A1 to D5.
Thanks
On 3 Jul 2013 10:41, Prafull Jadhav prafulltjad...@gmail.com wrote:
Dear All,
Good Morning..
I got below macro from net ..Can you explain me what x stand
Dear All,
Good Morning..
I got below macro from net ..Can you explain me what x stand here...
*Sub Upper_()*
*For Each x In Range(A1:D5)*
*'For Each x In Range(A1:D5)*
*
*
*x.Value = UCase(x.Value)*
*'x.Value = UCase(x.Value)*
*
*
*Next*
*
*
*Thanks in Advance.*
*Regards,*
*Prafull Jadhav
Thanks once again.Madam
On Fri, Jun 21, 2013 at 11:48 AM, priti verma pritiverma1...@gmail.comwrote:
Yes you can do it with macro,
See pfa
On Fri, Jun 21, 2013 at 11:29 AM, Prafull Jadhav prafulltjad...@gmail.com
wrote:
Dear Madam,
Thanks a lot ...
Can we make it from macro
Dear Expert,
Dear All, My date is horizontal ..i want to pull it in one column . thanks
in advance Regards,
Prafull Jadhav.
--
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
Dear Madam,
Thanks a lot ...
Can we make it from macro ...
Regards,
Prafull Jadhav.
On Fri, Jun 21, 2013 at 11:24 AM, priti verma pritiverma1...@gmail.comwrote:
Hi prafull,
PFA
On Fri, Jun 21, 2013 at 11:16 AM, Prafull Jadhav prafulltjad...@gmail.com
wrote:
Dear Expert,
Dear All
Dear All,
find the excel sheeti need macro for the same
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,
Dear XLS,
if we not declarer variable , will code run properly .?
suppose ...we write code as per below.
Sub conditionalreplace()
For Each Range In Range(D1:D10)
If Range.Value 0.8 Then
Range = .80
End If
Next
End Sub
if not ...Please
1 - 100 of 142 matches
Mail list logo