$$Excel-Macros$$ Excel Free Webinar

2017-08-06 Thread Rajan Verma
Book your slot right now https://www.itchat.in/microsoft-excel-vba-half-day-class/ RV -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

$$Excel-Macros$$ Excel VBA Training

2017-07-28 Thread Rajan Verma
[image: Inline image 1] -- 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

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-18 Thread Rajan Verma
le Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https:

Re: $$Excel-Macros$$ 達賴分裂,自尋死路

2017-06-18 Thread Rajan Verma
s not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups &

Re: $$Excel-Macros$$ 關於宗教的思考

2017-06-17 Thread Rajan Verma
nd stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d

Re: $$Excel-Macros$$ Hot List of R2Technologies

2017-06-16 Thread Rajan Verma
stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/

Re: $$Excel-Macros$$ Re: Required break chart in excel

2017-06-16 Thread Rajan Verma
so you have already got it. Regards Rajan On Fri, 16 Jun 2017 at 12:08 PM, amar takale <amartak...@gmail.com> wrote: > > http://www.exceldashboardtemplates.com/how-to-show-gaps-in-a-line-chart-when-using-the-excel-na-function/ > > On Thu, Jun 15, 2017 at 12:53 PM, Rajan

$$Excel-Macros$$ Re: Required break chart in excel

2017-06-15 Thread Rajan Verma
show me some image to replicate the chart. Regards Rajan Verma On Tuesday, 6 June 2017 05:39:58 UTC-6, amar takale wrote: > Dear all friends > > I Required break chart in excel.between data if there are blank cell then > chart show break. > > Actually in blank cell there

$$Excel-Macros$$ Re: Show Differences Between Buy & Sales in Pivot table

2017-06-06 Thread Rajan Verma
alternatively put minus signs in all the sales transactions but > that is not possible for a big database.* > > Any easy alternative solution will be highly appreciable. > > Thanks in advance. > B. Sharma > > -- Regards Rajan verma +91 7838100659 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ List of unique items

2016-07-11 Thread Rajan Verma
look at the attached file. On Friday, 27 May 2016 03:47:34 UTC-6, Abhi wrote: > > Please share an example workbook. > > On Fri, May 27, 2016 at 3:10 PM, Louis Omoya > wrote: > >> Hi all? Thid is my first post in the group. I appreciate the support >> online communities

$$Excel-Macros$$ Re: URGENT HELP( CONDITION SEARCH OF UNIQUE TEXT)

2014-10-01 Thread Rajan Verma
in J1 =LOOKUP(1,N(COUNTIF(D2:H2,D2:H2)1))=1 Regards Rajan. On Thursday, 25 September 2014 11:15:01 UTC-6, SUDHIR VERMA wrote: Dear Experts, Kindly resolve my problem. Explanation in attached workbook. Thanking You Regards Sudhir -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ Please solve this sheet its very urgent

2014-08-16 Thread Rajan Verma
Wow On Monday, 11 August 2014 12:57:05 UTC-6, kapil Gupta wrote: Thanks you really genius. Regards, Kapil Gupta On Monday, August 11, 2014 3:57:39 PM UTC+5:30, Vabz wrote: Hi FA Cheers!! On Mon, Aug 11, 2014 at 1:03 PM, kapil Gupta kgup...@gmail.com wrote: Hello, Please

$$Excel-Macros$$ Re: 4 quadrants graph help required

2014-03-03 Thread Rajan Verma
see the attached. On Monday, 3 March 2014 01:55:00 UTC-7, rekha siri wrote: Hi Friends, Please need your expert help in building 4 quadrant graph help. Below is data for which 4 quadrant graph is required. Company Spend Risk A 10 5% B 10

$$Excel-Macros$$ Re: Count of 1, 2, 3..... in a range

2014-03-03 Thread Rajan Verma
Put your number like 1,2,3 in B3 and so on and apply this formula with CSE in C3, c4 and so on. =SUM(N(VALUE(TRIM(MID(SUBSTITUTE($B$1:$FP$1,,,REPT( ,LEN($B$1:$FP$1))),((ROW(INDIRECT(1:LEN($B$1:$FP$1)))-1)*LEN($B$1:$FP$1)+1),LEN($B$1:$FP$1=B3)) On Saturday, 1 March 2014 04:30:53 UTC-7,

$$Excel-Macros$$ Re: Array from range

2014-03-03 Thread Rajan Verma
you should give column dimension in this below line BETADEG(s) it should be like BETADEG(s,1) On Friday, 28 February 2014 07:23:35 UTC-7, Gerrit Grundling wrote: Greetings, all What am I doing wrong here? I am trying to create an array from a range, but keep getting the Run-time error

$$Excel-Macros$$ Re: Two-dimensional interpolation

2014-03-03 Thread Rajan Verma
Hi make your array as double data type not Long Thanks Rajan. n Wednesday, 26 February 2014 07:07:45 UTC-7, Gerrit Grundling wrote: Greetings, all I have attached some aerofoil data for a Clark Y foil. This data is also available in my spread sheet. The Reynolds number is given

Re: $$Excel-Macros$$ Excel Formula - Huge Formula - Help to simplfy

2014-01-16 Thread rajan verma
to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Rajan verma +91 7838100659 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ how to unhide multiple sheets at once in excel 2007

2013-09-28 Thread rajan verma
select sheets tab with control button and press alt h h On 28 Sep 2013 13:04, ashish koul koul.ash...@gmail.com wrote: Sub unhide_specific_worksheets() Dim abc() Dim wk As Worksheet Dim i As Integer abc = Array(Sheet1, Sheet2) For i = LBound(abc) To UBound(abc) For Each wk In

Re: $$Excel-Macros$$ paste special particular formula

2013-09-27 Thread rajan verma
the macro code in it. But it is giving wrong results. Plz check. Regards, Mukesh Kumar On Thu, Sep 26, 2013 at 9:45 PM, rajan verma rajanverma1...@gmail.comwrote: use this one. Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim

Re: $$Excel-Macros$$ paste special particular formula

2013-09-27 Thread rajan verma
-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Rajan verma +91 7838100659 -- Are you =EXP(E:RT

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread rajan verma
to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Rajan verma +91 7838100659 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread rajan verma
On Thu, Sep 26, 2013 at 3:39 PM, rajan verma rajanverma1...@gmail.comwrote: HI Mukesh i have seen this query many time on this group and another forums, please try this macro Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim

Re: $$Excel-Macros$$ paste special particular formula

2013-09-26 Thread rajan verma
MsgBox strFormula has been replaced in lngCount Cells, vbInformation End Sub On Thu, Sep 26, 2013 at 10:14 AM, rajan verma rajanverma1...@gmail.comwrote: Try this one Sub PasteFormula() Dim rngRange As Range Dim VarArr Dim strFormula As String Dim varEle Dim

Re: $$Excel-Macros$$ Array - Unique list

2013-09-25 Thread rajan verma
. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Rajan verma +91 7838100659 -- 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

Re: $$Excel-Macros$$ Facing 'run-time error -2147217871 (80040e31) Automation error' in excel VBA

2013-09-25 Thread rajan verma
recheck your connection string and where you are getting this error On 25 Sep 2013 12:26, Junaid junaid.an...@gmail.com wrote: Hi guys, I am working on Excel 2007 macros. My requirement is to access MS SQL server DB from excel, using VBA. I am just trying to pull some data by connecting to

$$Excel-Macros$$ Need a Fastest way

2013-06-19 Thread rajan verma
can anyone suggest a faster way to know which cells are highlighted in a Range ? suppose i have data of 1 lac cell and i have some cells highlighted , i want to know address of that cells. -- Regards Rajan verma +91 9158998701 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Re: bubbel chart help required.

2013-03-22 Thread rajan verma
://groups.google.com/groups/opt_out. -- Regards Rajan verma +91 9158998701 -- 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

$$Excel-Macros$$ My Excel is Crashing!!

2013-03-14 Thread rajan verma
New thread i know , every user face it lets post here the possible reasons of crashing excel and find out the way to get rid of it. -- Regards Rajan verma +91 9158998701 -- 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

Re: $$Excel-Macros$$ I want to merge two text cell

2013-03-06 Thread rajan verma
/opt_out. -- Regards Rajan verma +91 9158998701 -- 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

Re: $$Excel-Macros$$ Need to Subtract Two Date/Time Cells - Formula Issue

2013-03-05 Thread rajan verma
. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Rajan verma +91 9158998701 -- 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

Re: $$Excel-Macros$$ shuffle cell value in excel

2013-03-05 Thread rajan verma
. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Rajan verma +91 9158998701 -- 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

Re: $$Excel-Macros$$ Query

2013-02-08 Thread rajan verma
/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Rajan verma +91 9158998701 -- 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

Re: $$Excel-Macros$$ IF Problem

2013-02-08 Thread rajan verma
/opt_out. -- Regards Rajan verma +91 9158998701 -- 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

Re: $$Excel-Macros$$ Match a Word in a cell using Macros

2013-02-07 Thread rajan verma
it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Rajan verma

Re: $$Excel-Macros$$ Enquiry about VBA

2013-02-07 Thread rajan verma
. -- Regards Rajan verma +91 9158998701 -- 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

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

2013-02-02 Thread rajan verma
this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Rajan verma +91 9158998701 -- 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

$$Excel-Macros$$ Getting Email Pattern

2013-02-01 Thread rajan verma
-- Regards Rajan verma +91 9158998701 -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

Re: $$Excel-Macros$$ Getting Email Pattern

2013-02-01 Thread rajan verma
ashish , can you explain On Fri, Feb 1, 2013 at 10:27 AM, koul.ash...@gmail.com wrote: ** Use Fn first name Fni or fi first intial Ln last name Lni or li last name intial Sent on my BlackBerry® from Vodafone -- *From: * rajan verma rajanverma1...@gmail.com

Re: $$Excel-Macros$$ Certification

2013-01-31 Thread rajan verma
://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Regards Rajan verma +91 9158998701 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ HyperLinks to Sheets

2013-01-16 Thread rajan verma
Rajan verma +91 9158998701 -- 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, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-11 Thread rajan verma
Hi Please find attachement Rajan On Fri, Jan 11, 2013 at 12:49 AM, Satendra kumar satendrakuma...@gmail.comwrote: Dear Rajan ji, Please find attachment solve , thankx satendra On Fri, Jan 11, 2013 at 1:13 PM, rajan verma rajanverma1...@gmail.comwrote: can be done with using

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member December'12

2013-01-10 Thread rajan verma
Glad to see this mail for you, keep it up good work.. Congrats :) Rajan verma On Fri, Jan 11, 2013 at 12:10 AM, amar takale amartak...@gmail.com wrote: Dear Prince, Congratulations my friend, well done and keep it up excellent work for our group. Warm Regards, Amar On Fri, Jan 11

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-10 Thread rajan verma
to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Regards Rajan verma +91 9158998701 -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

Re: $$Excel-Macros$$ Unsubscribe my email id

2012-12-24 Thread rajan verma
To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. On Mon, Dec 24, 2012 at 1:13 PM, jaspreet singh jas_sar...@yahoo.comwrote: To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Regards Rajan verma +91

Re: $$Excel-Macros$$ formula

2012-02-27 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ Fill Color in Shape

2012-01-01 Thread rajan verma
Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't

Re: $$Excel-Macros$$ Excel - Cell color actions

2011-12-30 Thread rajan verma
Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't

Re: $$Excel-Macros$$ Disable delete

2011-12-30 Thread rajan verma
to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

Re: $$Excel-Macros$$ dob

2011-12-29 Thread rajan verma
and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members

Re: $$Excel-Macros$$ Macro work

2011-12-14 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

Re: $$Excel-Macros$$ COUNT Unique using Frequency

2011-12-14 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Cell editing VBA

2011-12-14 Thread rajan verma
. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934

Re: $$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

2011-12-14 Thread rajan verma
to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need

Re: $$Excel-Macros$$ No. of Occurrence of char in string

2011-12-12 Thread rajan verma
to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

Re: $$Excel-Macros$$ Re: Convert XLS to XML

2011-12-12 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ text assignment to the textbox control

2011-12-11 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Conditional Formatting using named ranges

2011-12-10 Thread rajan verma
owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members

Re: $$Excel-Macros$$ I can’t understand why I m unable to do sum

2011-12-07 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Formula Help

2011-12-07 Thread rajan verma
loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ Progress bar - urgent

2011-12-07 Thread rajan verma
for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ How can click on HTML button using it's class.

2011-12-07 Thread rajan verma
-- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may

Re: $$Excel-Macros$$ Working in multiple workbooks

2011-12-06 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ Working in multiple workbooks

2011-12-06 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ Comvert Excel/CSV to XML

2011-12-06 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ Auto schedule for execution of macro

2011-12-06 Thread rajan verma
or we need to open the macro sheet and then  fix the reminder. Thanks, Rekha On Sun, Dec 4, 2011 at 7:00 PM, rajan verma rajanverma1...@gmail.comwrote: Sub Test() Application.onTime now+timevalue(00:30:00),ProcedureName end sub it means after 30 minute from now procedure

Re: $$Excel-Macros$$ update link automatically in excel sheet

2011-12-06 Thread rajan verma
owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members

Re: $$Excel-Macros$$ How to close many files at a time

2011-12-06 Thread rajan verma
-- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't

Re: $$Excel-Macros$$ Auto schedule for execution of macro

2011-12-04 Thread rajan verma
in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES

Re: $$Excel-Macros$$ Data validation not working properly

2011-12-03 Thread rajan verma
and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members

Re: $$Excel-Macros$$ fso

2011-12-03 Thread rajan verma
loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise

Re: $$Excel-Macros$$ What does -- suggest in formula.

2011-12-03 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

Re: $$Excel-Macros$$ recording macros

2011-12-03 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Correction in Formula

2011-12-03 Thread rajan verma
and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already

Re: $$Excel-Macros$$ Indirect Function

2011-12-03 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ About Marcros in 2007

2011-12-03 Thread rajan verma
@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention

Re: $$Excel-Macros$$ About Marcros in 2007

2011-12-03 Thread rajan verma
please ignore that post., You can download this book.. http://www.rencross.co.uk/ebookshelf/Microsoft/Visual%20Basic/Office/VBA/Excel%202007%20Power%20Programming%20With%20VBA.pdf On Sat, Dec 3, 2011 at 8:43 PM, rajan verma rajanverma1...@gmail.comwrote: hi its a strange problem but hope

Re: $$Excel-Macros$$ ActiveX Setting in Excel 2003

2011-12-03 Thread rajan verma
@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may

Re: $$Excel-Macros$$ Most Helpful Member Nov'11 - Sam Mathai Chacko

2011-12-02 Thread rajan verma
-- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2

Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers

2011-12-02 Thread rajan verma
, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

Re: $$Excel-Macros$$ Help me with a macro

2011-11-27 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help

Re: $$Excel-Macros$$ regarding date changing method

2011-11-15 Thread rajan verma
. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem

Re: $$Excel-Macros$$ Modify code to lock multiple sheets in a spreadsheet.

2011-11-11 Thread rajan verma
. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com -- Regards Rajan verma +91 9158998701 -- FORUM RULES

Re: $$Excel-Macros$$ Spell Check and Highlighting Individual Words

2011-10-13 Thread rajan verma
://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Average

2011-10-13 Thread rajan verma
on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

Re: Fw: $$Excel-Macros$$ Help required

2011-10-13 Thread rajan verma
link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

Re: $$Excel-Macros$$ file browser

2011-10-12 Thread rajan verma
://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701

Re: $$Excel-Macros$$ Cannot display properties of ActiveX checkbox that has been added through VBA

2011-10-12 Thread rajan verma
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701

Re: $$Excel-Macros$$ Pasting a button onto multiple sheets

2011-10-12 Thread rajan verma
our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Pasting a button onto multiple sheets

2011-10-12 Thread rajan verma
'!A1, Click Me, Index shButton.TextFrame.Characters.Text = Index Set sh = Nothing End If Next End Sub On Wed, Oct 12, 2011 at 9:26 PM, rajan verma rajanverma1...@gmail.comwrote: I Create a macro to an Index Sheet.. Hope it will be Usable Sub

Re: $$Excel-Macros$$ Cannot display properties of ActiveX checkbox that has been added through VBA

2011-10-12 Thread rajan verma
if you want to see the Properties .. you can select Property Option from Developer Tab in Control Menu On Wed, Oct 12, 2011 at 8:48 PM, rajan verma rajanverma1...@gmail.comwrote: Dont Use Shapes , use this Code ActiveSheet.OLEObjects.Add(classtype:=Forms.Checkbox.1) On Wed, Oct 12

Re: $$Excel-Macros$$ Dynamic chart range

2011-10-12 Thread rajan verma
at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91

Re: $$Excel-Macros$$

2011-10-10 Thread rajan verma
... !! Few months back, I also had one software viz Bad Copy Pro which I used to recover corrupted fils, which I lost - not sure if you also have such kind of software. Thanks, DILIPandey On 10/6/11, rajan verma rajanverma1...@gmail.com wrote: hi See the attached Workbook,i think some

Re: $$Excel-Macros$$ A macro pauses execution for no reason

2011-10-08 Thread rajan verma
://www.facebook.com/discussexcel -- Sent from my mobile device Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ Need Help

2011-10-05 Thread rajan verma
link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

Re: $$Excel-Macros$$ I need help

2011-10-05 Thread rajan verma
to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links

Re: $$Excel-Macros$$ Help, Alert MsgBox Pair duplicate entry in row

2011-10-05 Thread rajan verma
row good solution you propose, but only in column B duplicate Thanks Rajan 2011/10/4 rajan verma rajanverma1...@gmail.com Try this Code : this Code enable you to check the duplicate entry at the time of Data Entry .. Private Sub Worksheet_Change(ByVal Target As Range) Dim

Re: $$Excel-Macros$$ Dashboards

2011-10-04 Thread rajan verma
, Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ find doubling

2011-10-04 Thread rajan verma
Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ ragarding date format in excel vba

2011-10-04 Thread rajan verma
Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701

Re: $$Excel-Macros$$ Urgent Help!

2011-10-04 Thread rajan verma
and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701

  1   2   >