PFA
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mathan
Sent: 10 May 2013 12:55
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Expert help needed - Select the rows based on
the columns (using VBA or formula) . -URGENT
I have ready code for this
http://excelpoweruser.wordpress.com/2012/09/03/bubble-chart/
On Thursday, 21 March 2013 00:46:03 UTC-6, midhun wrote:
hi all;
i want to create the bubble chart of the following data.
not able to create as all the data is not reflecting.
also the x axis
Use this
=MAX(DATE(D$1,MONTH($C2),DAY($C2))-$B2,0)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rashid Khan
Sent: 19 February 2013 1:41
To: excel-macros@googlegroups.com
Subject:
Hi Deepak
See the attached Example,
There are 4 set of data , I give name them like data 1 , data2 ,data3 and
data4 , then I insert a camera tool and reference them by a name range
rngRange as you can understand in the attachment
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
I have year only two dimension in excel. One is vertical another one
horizontal , for that we have Vlookup and HLookup , I don't think if any
Ylookup is there J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
Shortest is this
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: 15 February 2013 4:34
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query
Hi Chauan,
Hi,
you can find a good example of Using class module in Excel VBA here
http://excelpoweruser.wordpress.com/2012/08/28/assign-event-to-a-bunch-of-controls/
Regards
Rajan verma
On Tuesday, 8 January 2013 20:50:16 UTC-7, Enrique Martin wrote:
Paul described wonderfully. Class Module are very
Sumproduct is not written in this way to use the operator as string, i
did'nt saw any example like this in last 4-5 years
Rajan
On Wednesday, 9 January 2013 01:06:35 UTC-7, Aashish Watve wrote:
Hi All,
I am seeing many examples of SUMPRODUCT formula on this forum and very
interested in
Dim Shp As Shapes
Set Shp = Sheet1.Shapes
shp object will have all shapes reference with in sheet1, you can use
shp(1) to color the first shape
Rajan
On Tuesday, 8 January 2013 21:38:13 UTC-7, Amol J wrote:
Thanks Divaker
Regards
Amol
On Tue, Jan 8, 2013 at 6:46 PM, Divaker
HI Noorain .
wish you a great New year and Happy b day,
have a great year ahead
Regards
Rajan verma
On Wednesday, 2 January 2013 00:13:59 UTC+5:30, ashish wrote:
Happy b'day Noorain Ansari
Regards
Ashish Koul
Sent on my BlackBerry® from Vodafone
--
Join official Facebook page of
Hi Dhaval,
i have created something for you, may be it can help you,
Download the heat map from here
http://www.excelfox.com/forum/f20/heat-map-739/
Regards
Rajan verma
On Monday, 31 December 2012 12:25:09 UTC+5:30, Dhaval Shah wrote:
*HELLO EXPERTS ANY SOLUTIONS ??*
-- Forwarded
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shiva Prasad
Sent: 29 December 2012 2:40
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ required the working hours calc(8 a.m to 8p.m)
How would you identify the hours with any given time ???
There are only dates in your data without times, so you can't get the aging
lesser than 24 Hours ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On
,
send the solution i am waiting
On Sat, Dec 29, 2012 at 4:27 PM, Rajan_Verma rajanverma1...@gmail.com
wrote:
How would you identify the hours with any given time ???
There are only dates in your data without times, so you can't get the aging
lesser than 24 Hours ?
Regards
Rajan verma
to 8p.m)
Dear Rajan,
am taking holiday Sunday and time Calclation taking 24 hours,
my working hours time 8am to 8pm.
please provide me solution
On Sat, Dec 29, 2012 at 3:28 PM, Rajan_Verma rajanverma1...@gmail.com
wrote:
Regards
Rajan verma
+91 7838100659 tel:%2B91
Required
i want the solution by if formula like
if is greater than column wise
On Sat, Dec 29, 2012 at 5:06 PM, Rajan_Verma rajanverma1...@gmail.com
wrote:
Enjoy
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros
Looks nice now :)
On Thursday, 20 December 2012 03:31:21 UTC+5:30, Bullet wrote:
Hi All,
Kindly find attached the Numeric Typing Tutor_V1, made in MS-Excel.
And append your suggestion to make it more dynamic.
Few months back Mr. Rajan Verma, helped me a lot to make it, thanks a lot
In K7
=INDEX(E7:H7,,MATCH(MAX(COUNTIF(E7:H7,E7:H7)),COUNTIF(E7:H7,E7:H7),0))
With CSE
On Thursday, 13 December 2012 13:00:03 UTC+5:30, amar takale wrote:
Dear all
Can Anybody tell me formula to merge cell entry in one column if it is
duplicate then over right on it
Regards
Amar
--
Why you want to have same name?
On Monday, 17 December 2012 09:29:13 UTC+5:30, Sanjay Kumar Maurya wrote:
Dear All,
I'm inserting new sheet in a workbook but all sheet have a different name
like sheet1, sheet2.
but i want,
if I'm inserting new sheet then every time they have same name!
Ozgrid.com
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Manjunath Narayanappa
Sent: 14 December 2012 7:03
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ Link or Group to Join
See if it helps
1) http://excelpoweruser.wordpress.com/2012/06/07/compile-worksheets/
2)
http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/
3) http://excelpoweruser.wordpress.com/2011/07/06/compiling-workbooks/
Regards
Rajan verma
+91 7838100659
, December 14, 2012 7:28:17 PM UTC+5:30, Rajan_Verma wrote:
See if it helps
1) http://excelpoweruser.wordpress.com/2012/06/07/compile-worksheets/
2)
http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/
3) http://excelpoweruser.wordpress.com/2011/07/06/compiling-workbooks
Vinay's worksheet is password protected, I think formula should be visible
to all
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: 14 December 2012 8:20
To:
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Consolidating Multiple files
may be i'm silly with the question, but really not getting it that you have
replied.
On Friday, December 14, 2012 8:16:28 PM UTC+5:30, Rajan_Verma wrote:
Ah..
You can add reference Microsoft scripting runtime
Regards
Yes
www.ozgrid.com
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Manjunath Narayanappa
Sent: 14 December 2012 8:25
To: 'excel-macros@googlegroups.com'
Cc: 'Rajan_Verma'
Subject: RE: $$Excel-Macros
Heartly Congrats Paul :)
On Monday, 3 December 2012 23:58:06 UTC+5:30, Ayush Jain wrote:
Dear members,
Paul Schreiner has been selected as 'Most Helpful Member' for the month of
Nov'12. He has posted 52 posts last month and helped forum members through
his excel expertise.
I truly
You can go here and can modify the code as per your need
http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mel
Sent: 27
,
Please find the attachment. I had been given to another
solution.
Regards,
Excel Beginner
On Sat, Nov 24, 2012 at 10:11 AM, Rajan_Verma rajanverma1...@gmail.com
wrote:
HI,
As per your formula if you have 50 Rows you need 50 Index to do the same.
Good
.
Regards,
Excel Beginner
On Sat, Nov 24, 2012 at 10:11 AM, Rajan_Verma rajanverma1...@gmail.com
wrote:
HI,
As per your formula if you have 50 Rows you need 50 Index to do the same.
Good effort but it can be more better.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel
Press ALT+ E + K
See if any linked workbook Is there
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SAJID MEMON
Sent: 25 November 2012 9:01
To: Sundarvelan Natarajan
Subject: $$Excel-Macros$$ want
November 2012 11:54
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula Quiz
Hi Rajan Sir,
please find the attachment.
Regards,
Excel Beginner
On Fri, Nov 23, 2012 at 10:51 PM, Rajan_Verma rajanverma1...@gmail.com
wrote:
Hi Group,
here
Transpose work only on 65536 Rows
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince
Sent: 19 November 2012 11:18
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Type Mismatch error.
If words are separated by Space use this
=TRIM(RIGHT(SUBSTITUTE(A1, ,REPT( ,LEN(A1))),LEN(A1)*2))
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Natron
Sent: 19 November 2012 9:43
To:
Is it Extracting 2 words??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince
Sent: 19 November 2012 9:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Formula to grab last two
any prize for 10 :)
On Tuesday, 13 November 2012 23:59:19 UTC+5:30, Ayush Jain wrote:
Dear group,
Thanks for your participation in the quiz. There was very good response to
the quiz from the members of this forum.
Excel quiz : 250 responses
VBA quiz : 228 responses
I am enclosing the
Thanks All,
On Monday, 12 November 2012 10:24:55 UTC+5:30, ca_k...@yahoo.co.in wrote:
Congratulations Rajan
On Wed, Nov 7, 2012 at 6:17 PM, Karan Singh kara...@gmail.comjavascript:
wrote:
Congrats dude!!
Karan Singh
On Tue, Nov 6, 2012 at 5:51 PM, neeraj chauhan
Great
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of yogananda muthaiah
Sent: 10 November 2012 8:40
To: excel-macros
Subject: $$Excel-Macros$$ Microsoft 2010 Excel version Competetion going on
!!!
Yes
On Thursday, 8 November 2012 00:33:40 UTC+5:30, santosh wrote:
Hello,
Can the graph in the attchment be modified as per the below table.
If so would request you to please help me with this
Group110%
Group220%
Group330%
Group415%
Group5
for this solution.
Thanks regards
Ashish Bhalara
On Thu, Oct 25, 2012 at 8:53 AM, Rajan_Verma rajanverma1...@gmail.com wrote:
Hi
Download the file from here
http://www.excelfox.com/forum/f12/vlookup-return-multiple-values-4/
Thanks
Rajan.
On Wednesday, 24 October 2012 22:51:01
Is it picture format ?
If it is you need a software to open those file..
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of neeraj chauhan
Sent: 08 November 2012 5:49
To:
@googlegroups.com
Subject: Re: $$Excel-Macros$$ K.A. Mr.Rajan Verma: Help need to get multiple
values by vlookup
Dear Rajan,
Kindly tell Exactly what changes or modifications you have made to the code !
On Thu, Nov 8, 2012 at 6:31 PM, Rajan_Verma rajanverma1...@gmail.com wrote:
You can use this one
May be B Sharma Can help you on this forum.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajasekhar Praharaju
Sent: 08 November 2012 9:11
To: excel-macros@googlegroups.com
Subject:
Please have a look here
http://www.mrexcel.com/forum/excel-questions/554224-using-visual-basic-appli
cations-smart-art.html
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Paul Schreiner
Sent: 06
you will get what you want here ..
http://excelpoweruser.wordpress.com/2012/05/03/split-data-into-multiple-workbook/
Thanks
Rajan verma
On Tuesday, 6 November 2012 08:30:08 UTC+5:30, Somnath Khadilkar wrote:
On 11/4/12, Somnath Khadilkar khadi...@gmail.com javascript: wrote:
Dear SIrs,
So , how would you like to automate the process?
On Friday, 2 November 2012 01:39:51 UTC+5:30, Nevin wrote:
HI Rajan/Friends,
Thanks for your intrest in helping me.
Objective of the tool is to update all the test case results in QC from an
excel file through macros which inturn will
I dont think if there is any direct way
you can do this , if dont have any blank cells in your data,
1) Select your data
2) Repalce your value to blanks by Checking Match Entire Cell Contents in
Find Replace dialoge box ,
3). Press CTRL+G ( Go to)
4) Press ALT+S (Special)
5) Press K ( Blanks)
Private Sub Worksheet_Change(ByVal Target As Range)
'Your code goes here
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pawel lupinski
Sent: 02 November 2012 5:35
To:
For each cell in Range(A1).CurrentRegion.SpecialCells(xlcelltypevisible)
'Your code here
next
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of t vinay
Sent: 02 November 2012 8:11
To:
=DATE(D2,C2,B2)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Neeraj
Sent: 31 October 2012 11:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ need help
Dear Experts,
Kindly
Can you explain more?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Nevin Bennet
Sent: 31 October 2012 10:15
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Qc Results
is automatically getting protected.
It should be work manually (Protect/ UnProtect) and not automatically.
Please look in to this and inform. Thank you!
Regards
Pravin Gunjal
-- Forwarded message --
From: Rajan_Verma rajanverma1...@gmail.com
Date: Mon, Oct 29, 2012 at 10:05 AM
Execute it at 8 o clock
Sub ShowPopUp()
Msgbox Send Massange
Application.OnTime Now+Timevalue(01:00:00),ShowPopUp
End Sub
Sub StopPopUp()
On Error Resume next
Application.OnTime Now+Timevalue(01:00:00),ShowPopUp,,False
End sub
Regards
Rajan verma
+91 7838100659
=IF(ROUNDUP(MONTH($A2)/3,0)=COLUMNS($A$1:A1),$A2,)
Format as MMM
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Viswanathan Yoganathan
Sent: 27 October 2012 3:07
To:
=SUBSTITUTE(B1,A1,)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Saravanan
Sent: 27 October 2012 10:52
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Compre cells,
Try this
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With ThisWorkbook.Worksheets(Field Emails)
.Unprotect
[selRow] = Target.Row
[selCol] = Target.Column
.Protect
End With
End Sub
Regards
Rajan verma
+91
My internet not working these days. will come back to you shortly :)
On Thursday, 25 October 2012 10:34:33 UTC+5:30, vijay wrote:
Dear Rajan,
Excellent work buddy.Can you please mention the steps required to create a
chart like that?Does it work with Excel 2007?
Regards.
P.VIJAY KUMAR
Hi
you can visit here to learn all loop in vba
http://excelpoweruser.wordpress.com/2011/07/26/looping-in-vba/
Thanks
Rajan.
On Friday, 26 October 2012 02:26:27 UTC+5:30, Greg wrote:
Hi,
I would like your help in writing a simple macro that will perform a
For/End loop around a .Range
Hi
Download the file from here
http://www.excelfox.com/forum/f12/vlookup-return-multiple-values-4/
Thanks
Rajan.
On Wednesday, 24 October 2012 22:51:01 UTC+5:30, saravanan R wrote:
Hi xlts,
Please help me, on how to get the all the associated items In the range
where it as more than
Can you share something like this ??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of KAUSHIK SAVLA
Sent: 22 October 2012 2:37
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Trouble in
Use this
Function AddOr(rngRange As Range) As String
If rngRange.Columns.Count 1 And rngRange.Rows.Count 1 Then
AddOr = Invalid Input
Exit Function
End If
If rngRange.Rows.Count 1 Then
AddOr = Join(Application.Transpose(rngRange), Or )
It seems that you copy it from somewhere, Just remove the inverted commas
and put them again
Private Sub CommandButton2_Click()
contents = Worksheets(Sheet1).Range(A1).Value
MsgBox contents
' I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX
End Sub
You can extract number only form a string without vba,
Anyway ,here is a VBA code to extract NUMBER,TEXT,SPECIAL CHR from a string
= RemoveContents(StringToReplace, 1) ' To Remove Text
= RemoveContents(StringToReplace, 2) ' To Remove Number
= RemoveContents(StringToReplace, 3)
So what is the issue??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Umar Abeer
Sent: 23 October 2012 1:54
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re:Data Validation
Hi Guys
You will get desired here..
http://www.excelfox.com/forum/f13/excel-dynamic-waterfall-chart-317/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of prkhan56
Sent: 20 October 2012 10:03
To:
can,
As long as ever you can. - John Wesley
-
_
From: Rajan_Verma rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tue, October 23, 2012 10:24:20 AM
Subject: RE: $$Excel-Macros$$ MsgBox Query
It seems that you copy it from
Sub DoSomething()
Sheet1.Unprotect Pwd
'Your code goes here
Sheet1.Protect Pwd
End sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pravin
: $$Excel-Macros$$ Solve the problem
Thanks Sir and If I want to calculate on 6days week format how Can I do it.
rajesh
On Wednesday, October 17, 2012 6:51:47 PM UTC+5:30, Rajan_Verma wrote:
Is it you are looking for?
=NETWORKDAYS(A2,A2+25,$E$2:$E$17)
Regards
Rajan verma
+91
please can any one explain me
What is the purpose of making true at end?
Aging I ma repeating this is just for Knowledge.
Regards
Shrinivas
On Fri, Oct 19, 2012 at 6:29 PM, Rajan_Verma rajanverma1...@gmail.com
wrote:
But also make them TRUE at end of code
Regards
Rajan verma
+91
But also make them TRUE at end of code
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: 19 October 2012 5:25
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Try this
ActiveChart.ChartArea.Format.Fill.GradientStops.Insert(RGB)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Daniel
Sent: 20 October 2012 12:57
To: excel-macros@googlegroups.com
Subject:
Will you please elaborate ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: 17 October 2012 11:40
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro Help: Repeat
Is it you are looking for?
=NETWORKDAYS(A2,A2+25,$E$2:$E$17)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajesh Agarwal
Sent: 17 October 2012 3:46
To: excel-macros@googlegroups.com
I can help you to Convert a Table into HTML Format
Visit here..
http://excelpoweruser.wordpress.com/2012/08/13/html-body-of-a-table/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Vignesh S
Use this .
Sub GotoSheet()
Dim StrString As String
Dim VarSheetArr
Dim wksSheet As Worksheet
Dim VarCount
VarCount = 1
For Each wksSheet In ThisWorkbook.Worksheets
StrString = StrString VarCount vbTab wksSheet.Name vbCrLf
-Macros$$ Solution required
Dear Rajan
Please elaborate how it will work.
Thanks,
Pravin Gunjal
-- Forwarded message --
From: Rajan_Verma rajanverma1...@gmail.com
Date: Sat, Oct 13, 2012 at 11:39 AM
Subject: RE: $$Excel-Macros$$ Solution required
To: excel-macros
answers for this one
!
Sent on my BlackBerryR from Vodafone
_
From: Rajan_Verma rajanverma1...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 13 Oct 2012 00:21:15 +0530
To: excel-macros@googlegroups.com
ReplyTo: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Best
VBA Guide is nice
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince Sethi
Sent: 13 October 2012 10:02
To: akhileshkumar.v...@gmail.com; amarjeet_sing...@rediffmail.com;
anitarwt...@gmail.com;
Your Query subject does not match with you query
You can use
APplication.OnKey ShotCutKey,SubName
to assign ShortCut key to any sub Procedure
Rajan.
On Friday, 12 October 2012 05:52:59 UTC+5:30, Shri wrote:
Good Morning All,
I am new to this forum. Need a macro code which may work
access-...@googlegroups.com
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of santosh subudhi
Sent: 12 October 2012 3:15
To: excel-macros
Subject: $$Excel-Macros$$ Email address for ms access forum
What??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Harkesh Kumar
Sent: 12 October 2012 2:45
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
--
Join official facebook page of
You can join this group for MS Access and SQL regarding query, although
group is recently started but Experts are here to make you expert J
https://groups.google.com/group/access-sql?hl=en
https://groups.google.com/group/access-sql?hl=enpli=1 pli=1
Regards
Rajan verma
+91 7838100659
What is the best thing you do/Can do with Excel?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles.
...@gmail.com wrote:
Actually I don't know about the coding in vba where I can learn coding for
vba. I know only record macro. I want to do coding in my way. What I want I
get it from my data.
Thanks
Manoj
On Oct 10, 2012 11:20 PM, Rajan_Verma rajanverma1...@gmail.com wrote:
Just a quick Example :
1
Regars
Ahmed Bawazir
On Wed, Oct 10, 2012 at 7:16 PM, Rajan_Verma
rajanverma1...@gmail.comwrote:
* *
*Just sharing fun with charts.*
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
** **
--
Join official facebook page of this forum @
https://www.facebook.com
Select Formula Cell and press Ctrl+ [
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh Kumar Sharma
Sent: 11 October 2012 5:44
To: excel-macros@googlegroups.com; NOORAIN ANSARI
Subject: Re:
When you move your worksheet.. your Code written in Worksheet Code window
will automatically move with it
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: 11 October 2012 6:14
To:
Just sharing fun with charts.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Just a quick Example :
1) You are an analyst in Vodafone, you daily receive lot of Customer
application form on your mail in Excel Sheet, and you want to know -
a. how many are from Gurgaon, Delhi,Noida ??
b. How many are Corporate Connection ?
c. Count of different
Visit here:
http://excelpoweruser.wordpress.com/2011/07/30/remove-special-character-from
-a-string/
Public Function SheetName(Shname As String) As String Dim Cod As Integer Dim
ShN As String
For i = 1 To Len(Shname)
Cod = Asc(Mid(Shname, i, 1))
=COUNTIFS(A2:A12,Karthik,B2:B12,Collected)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of karthik N
Sent: 05 October 2012 8:23
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need
How many Sheets this workbook have ?
do you remember all worksheet name?
you can write formual to recover the contain only but not formating
='fullpathofworkbook[WorksheetName]'!A1
Drag this formula below and right
Rajan.
On Thursday, 4 October 2012 08:57:17 UTC+5:30, B Sharma wrote:
Dear
Hi neeraj ,
you can use this
=IF(HOUR(TIMEVALUE(RIGHT(A2,8)))12,Night,Day)
On Thursday, 4 October 2012 14:40:45 UTC+5:30, neeraj chauhan wrote:
Dear Experts
Kindly see the attached sheet and urgently req.
--
Join official facebook page of this forum @
Did try yet, can you explain what you do actually ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of mburkett
Sent: 04 October 2012 12:29
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
Hi,
Use this Code, Just Create Two Name Ranges,
Sheet1!B2=rngRange
Sheet2!B2 = MapDelete
Sub ExcludeFromList()
Dim objDicMap As Object
Dim VarArrData
Dim VarArrResult
Dim rngCell As Range
Dim lngCOunt As Long
VarArrData =
Here is thread on this Solution , Please visit
http://www.excelfox.com/forum/f20/delete-list-contain-matching-second-list-5
89/
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: 04 October 2012 9:58
To: 'excel-macros
Array Formula
=IFERROR(SMALL(IF(ISERROR(MATCH(ROW(INDIRECT(MIN(g):MAX(g))),g,0)),ROW(INDIRECT(MIN(g):MAX(g))),),ROW(INDIRECT(1:COUNT(IF(ISERROR(MATCH(ROW(INDIRECT(MIN(g):MAX(g))),g,0)),ROW(INDIRECT(MIN(g):MAX(g))),),)
g is your list name.
Rajan
On Thursday, 4 October 2012 19:14:56
Thanks to all.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of NOORAIN ANSARI
Sent: 03 October 2012 5:14
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rajan Verma - Most Helpful
=B2-A2
Apply [m] as custom format
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Chandra Shekar
Sent: 03 October 2012 6:34
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$
Is your data suitable for all chart type ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mangesh Vimay
Sent: 03 October 2012 6:39
To: excel-macros@googlegroups.com; Mangesh Vimay
Subject:
,
I tried the formula still its have some issues could you please check it
out.
Thanks in advance.
On Wed, Oct 3, 2012 at 3:13 PM, Rajan_Verma rajanverma1...@gmail.com
wrote:
=B2-A2
Apply [m] as custom format
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From
1 - 100 of 1063 matches
Mail list logo
