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 <
&g
select that column -Text to Column ( in Data Tab) -Click Finish
Regards,
Prafull Jadhav
9920553518
On 27 August 2015 at 18:49, SUDHIR VERMA wrote:
> Dear Friends,
> Please help me as per attached sheet. I have data of 25k row. there are
> some code formatting as text. So you ar
Dear Shrinivas,
You will get this after selecting formula and Press F9
For example
select 1/(A2:A18=F3) and then Press F9
Regards,
Prafull Jadhav
9920553518
On 27 August 2015 at 18:05, Pankaj Sharma wrote:
> Hi Shrinivas,
>
>
> "($A$2:$A$17=F2)" Here, A2:A17 array chec
Great ...
Abhishekji
Regards,
Prafull Jadhav
9920553518
On 27 August 2015 at 15:51, Pankaj Sharma wrote:
> Thank you Abhishek Jain
>
> On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain
> wrote:
>
>> HTH
>>
>> On Thu, Aug 27, 2015 at 3:18 PM, Pankaj S
Dear Ashish,
Great!
You have given explanation Step by Step.
Regards,
Prafull Jadhav
9920553518
On 5 December 2014 at 17:13, Ashish Kumar 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 wrote:
> Hello Paul,
>
> First I would like to thank you from bottom of my *heart* for making such
> an *efficient code
Dear Vaibhav Sir,
Thanks for the shared us a very useful file.
Regards,
Prafull Jadhav
9920553518
On 18 September 2014 17:32, Ganesh N wrote:
> Got it sir!! Thanks
>
> One more help sir. Like formulas do you have sample files for macros ?
> just to learn. im a beginner to macro.
Dear Vaibhavji,
Great!
Regards,
Prafull Jadhav
9920553518
On 8 September 2014 12:55, Vaibhav Joshi 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.*
>
> O
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 wrote:
>
> Hello Experts
> I am using office 2013, when download any macro included workbook from
> this gro
Dear All,
Wish you very very happy Independence day.
Regards,
Prafull Jadhav
9920553518
On 14 August 2014 13:24, Vaibhav Joshi 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 of
find the same...
Regards,
Prafull Jadhav
9920553518
On 8 August 2014 16:39, Prafull Jadhav wrote:
> find the same
>
> Regards,
> Prafull Jadhav
> 9920553518
>
>
> On 8 August 2014 16:19, Mihai Ghilea wrote:
>
>> Try this...
>>
>>
>>
>&g
find the same
Regards,
Prafull Jadhav
9920553518
On 8 August 2014 16:19, Mihai Ghilea wrote:
> Try this...
>
>
>
> Mihai Ghilea
>
> Network administrator
>
> [image: Sigla_METABRAS_STEEL_PEOPLEmica]
>
> ROMANIA
>
> SC METABRAS SRL Brasov
>
> St
Dear Ashish,
Only one changes , Blink on the ( in Details sheets)...which cell is
selected or highlighted
Not on the index sheet.
for example :
once i click on hyperlink cell(in index) then the cell should be blink of
Details sheets which is selected.
Regards,
Prafull Jadhav
9920553518
On 5
ade it but it is not blinking.
Please check my excel file.
Regards,
Prafull Jadhav
9920553518
On 5 August 2014 15:11, Ashish Kumar wrote:
> Hi Prafull,
>
> PFA...!!!
>
>
> Regards
> Ashish
>
> On 5 August 2014 14:53, Prafull Jadhav wrote:
>
>> Dear Ashis
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 wrote:
> Hi Prafull,
>
>
> PFA.!!!
>
>
> Regards
> Ashish
>
>
>
!
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
Awesome!.Vaibhav Sir.
Thanks a Lot!
Regards,
Prafull Jadhav
9920553518
On 28 July 2014 12:28, Vaibhav Joshi 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 ra
Dear Vaibhav Sir,
Your formula is very good,Appreciate!
Can we do the same for bucket by using same technique.
for example
0-10,11-20,21-30
if cell is contain
7 then it should be come under 0-10 bucket
if cell is contain
22 then it should be come under 21-30 bucket.
Regards,
Prafull Jadhav
Abhishek Sir,
Again you proved that you are Master..!
Regards,
Prafull Jadhav
9920553518
On 27 May 2014 16:21, Abhishek Jain wrote:
> Happy to help :)
>
>
> On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal wrote:
>
>> Dear Abhishek Jee,
>>
>> It is
Dear Abhishek Sir,
Great.
Regards,
Prafull Jadhav
9920553518
On 17 April 2014 12:09, Abhishek Jain 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
> passwo
Dear Sir,
perfect !...
thanks a lot .
Regards,
Prafull Jadhav
9920553518
On 9 April 2014 16:11, Ravinder wrote:
> PFA...first select range of heading as I have already selected in file.
>
>
>
> *From:* excelvbacli...@googlegroups.com [mailto:
> excelvbacli...@goo
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) !
Please check and ..let me know.
Regards,
Prafull Jadhav
9920553518
On 17 March 2014 21:12, Prafull Jadhav wrote:
> Error status No Error ? C ? NC ?
>
> Error --How to find out Quality- how to find out
>
> Regards,
> Prafull Jadhav
> 9920553518
>
>
> On 17
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 wrote:
> can you workout and send me..i did tried.. but am not getting result.
>
> if you provide VBA code.. it would be
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
gives wrong Nos to Management.
Regards,
Prafull Jadhav
9920553518
On 15 March 2014 20:44, ravinder negi 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
stable average count.
if i include the Highest numbers in series then Average suddenly goes
up..and charts look like jumping at highest point.
for avoid this ..which type of formula i have to apply here which show
stable Average or Graphs.
Regards,
Prafull Jadhav
9920553518
--
Are you =EXP(E:RT) or
mulas 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
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$
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.co
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 wrote:
> D
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
ards,
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 Pl
Thanks a lot Sir..
Perfect!
Regards,
Prafull Jadhav
9920553518
On 4 March 2014 17:21, Paul Schreiner 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)&quo
If Selection.Offset(0, 2).Value = "HSR-JINDAL CLUB(HR)" Then*
*Selection.Offset(0, 12).Value = "Hisar"*
*ElseIf Selection.Offset(0, 2).Value = "HSR-JINDAL HOUSE" Then*
*Selection.Offset(0, 12).Value = "Hisar"*
*ElseIf Selection.Offset(0, 2).Value = "HSR-
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
s used for data 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 wrote:
> Hi Amar,
>
> it is simple index match formula and 1 indicates r
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 wrote:
> Dear Raviderji & Priti
>
> Thank very much for
Great Ravinder Sir..
Regards,
Prafull Jadhav
9920553518
On 28 February 2014 15:33, Ravinder 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 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 wrote:
> Pfa , first select
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
for example
if A1 contain words like "NO",YES,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 fo
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-ma
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)
wrote:
> In Macro use conditional Formatting..use Top 10 option..
>
>
>
> Regards,
>
> *Amit Desai *– MIS Manager
Sir, Can you tell me how to check and how modified
Regard,
Prafull Jadhav.
9920553518
On 25-Nov-2013 7:02 PM, "Papnay, Ashish" wrote:
> Hi Prafull,
>
>
>
> What is the format of date in your system.
>
>
>
> Like in my system the date formate is MM/DD/YY.
&
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" wrote:
> yeah, but can u share the snap shot..
>
> coz ur example sheet formula is workin
Same error which is in my first attachmentsir
Regard,
Prafull Jadhav.
9920553518
On 25-Nov-2013 1:53 PM, "xlstime" wrote:
> please share the snap shot
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Mon, Nov 25, 2013 at 1:50 PM
Dear Sir,
Same is working on other PC
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 25, 2013 at 1:49 PM, Prafull Jadhav wrote:
> Dear Sir,
> It is also not working ...
>
> Value error is there .
>
> Regards,
> Prafull Jadhav
> 9920553518
>
>
> On Mon,
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 wrote:
> you can try with "--"
>
> formula like =--A3
>
> .
>
> Enjoy
> Team XLS
>
..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
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" wrote:
> is it 1 apr 2013
>
> try to change the setting of ur computer control panel
Dear Sir,
It is not working .
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 18, 2013 at 3:40 PM, saurabh kumar
wrote:
> Hi Prafull,
>
> Please find attached & Check
>
> Regards
> Saurabh
>
>
> On Mon, Nov 18, 2013 at 1:11 PM, Prafull Jadhav
> wrote:
&
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 wrote:
> Hi, Try using below:
>
> Sub prafu()
> For Each x In Range("A1:A9000&quo
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
wrote:
> Hi Prafull,
>
> Please
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
wrote:
> Dear All,
> Very Good Morning ..and Have a Great Day Ahead!
>
> I got below Function from our group . I have modified it
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 by
Got it !
Thanks a lot
Regard,
Prafull Jadhav.
9920553518
On 24-Oct-2013 1:37 PM, "xlstime" wrote:
>
> sub rr()
> range("a1").value =date
> range("a2").value2=date
> end sub
>
>
> .
>
> Enjoy
> Team XLS
&
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 wrote:
> Value2 always uses the same value that Excel uses. It does not truncate
> decimal places ,Value2 gives you DateSerial
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:
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 wrote:
> For Each cell In Selection
>
> With cell.Characters(Start:=3, Length:=1).Font
>
> .Color = vb
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 Ja
Dear all,
I want function for coloring particular text. For example if cell contian
word 'prafull' and I want to red colors to 'l' character in cell.
Regard,
Prafull Jadhav.
9920553518
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(
Dear Ashish,
find the same with formula.
*Regards,
Prafull Jadhav
9920553518*
On Mon, Sep 23, 2013 at 1:39 PM, Ashish Kumar wrote:
> Dear Anil,
>
> Can you please help me to reslove this query through Excel formula.
>
> Thanks,
> Ashish
>
>
> On Monday, September
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 wrote:
> you can write udf to concatenate the range
>
>
> On Fri, Sep 13, 2013 at 6:39 PM, Prafull Jadhav
> wrote:
>
>> Dear All,
>>
>> Can we concatenate by
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,
P
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, अनिल नारायण गवली
wrote:
> Dear Ashish,
>
> Pl see the attached workbook.
> Is it ok?
t; Next
> End Sub
>
>
> On 07-09-2013 10:46, 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 .
>
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 mus
Remove* "" * from formula ...for number value
On Wed, Sep 4, 2013 at 2:25 PM, KAUSHIK SAVLA wrote:
> 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
> am getting is
ue remains same till "K" count = count no of active cells in row
> and its hold range("a2:a15")'s value
>
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Thu, Aug 29, 2013 at 9:18 AM, Prafull Jadhav
> wrote:
>
>> D
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, Praf
;a2:a15").Cells(K, 1)
> Next
> Next
>
> End Sub
>
>
> .
>
> Enjoy
> Team XLS
>
>
>
> On Wed, Aug 28, 2013 at 9:41 AM, Prafull Jadhav
> wrote:
>
>> Dear All,
>>
>> Very Good Morning ,
>>
>> I ha
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
=TIME(2,DO:IT,N:OW)
ull
End Sub
On Wed, Aug 21, 2013 at 2:25 PM, Prafull Jadhav wrote:
> Thanks a lot Sir...It working Fine
>
>
> On Wed, Aug 21, 2013 at 1:12 PM, xlstime wrote:
>
>> Try This
>>
>> Sub Chart_Titles()
>>
>> Dim ch As ChartObject
>
; Selection.Format.TextFrame2.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, Prafu
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 wrote:
> Dear Prafull Jadhav Ji,
> My concept is different, I have list of amount... if an
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 wr
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 wrote:
> Dear Expe
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 wrote:
> That is, you've almost done with it, jus
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,
Praf
ount)
> If InStr(1, Rng, "Days") > 0 Then
> Range("B" & Rng.Row & ":D" & Rng.Row) = _
> Split(Replace(Replace(Replace(Rng.Text, "Days ", ""), "Hrs ",
> ""), "Mins",
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 wrote:
> Sub test()
>
> For j = 1 To Ran
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/
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 wrote:
> if we have more then thousands of records than?
>
> .
>
> Enjoy
> Team XLS
>
>
>
>
; On Fri, Jul 26, 2013 at 4:47 PM, Prafull Jadhav
> wrote:
>
>> 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,
>>
>>
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 wrote:
> Check it and let me know is it ok.
>
>
>
> On Fri, Jul 26, 2013 at 4
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 wrote:
> Hi Prafull,
>
> Find attached the attractive chart as you requested.
>
> Thanks,
> Anil
>
>
> On F
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
t;|" & Range("A1")
>
> Please remember, that i in our code is refer to a Range as defined in
> first line => Dim i as Range
> And Range has default property => Value
> i.value will same as i
> Range("A1").value will same as just Range("A1"
swordrecoverysoftware.org/
> http://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, 201
Dear Paul Sir,
Thanks for the information . I will search it by Google. Henceforth same
will not happen again.
Regards
Prafull Jadhav.
On Tue, Jul 23, 2013 at 5:13 PM, Paul Schreiner wrote:
> See Forum Rules #3:
> "Don't post questions regarding breaking or bypassing any se
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 wrote:
> Hi Prafull,
>
> Please send the file.
>
>
> On Tue, Jul 23, 2013 at 11:30 AM, Prafull Jadhav
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 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
R
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)
wrote:
>
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 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)) in Excel?
1 - 100 of 155 matches
Mail list logo