$$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 Help

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

2017-06-18 Thread Rajan Verma
bscribed to the Google 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

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

2017-06-18 Thread Rajan Verma
opyrighted 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 > "MS EXCEL AND VBA

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

2017-06-17 Thread Rajan Verma
s 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/optout. > -- Re

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

2017-06-16 Thread Rajan Verma
> 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/optout. > -- Regards Rajan verma +91 7

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 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 Verma > wrote: > >>

$$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
he 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)) in Excel? And do you w

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 such as this offer. >> >>

$$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))

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 wrote: >> >>> Hello, >

$$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 i

$$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 e

$$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-

$$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% >

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

2014-01-16 Thread rajan verma
;> > 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 >> > "MS EXCEL AND

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" 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 ThisWo

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

2013-09-27 Thread rajan verma
assing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is 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

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

2013-09-26 Thread rajan verma
ote: > Rajan Ji, > > Plz see attached file. I have inserted 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 wrote: > >> use this one. >> >> Sub Past

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

2013-09-26 Thread rajan verma
heet.UsedRange.Value = VarArr Next wksSheet MsgBox strFormula & " has been replaced in " & lngCount & " Cells", vbInformation End Sub On Thu, Sep 26, 2013 at 10:14 AM, rajan verma wrote: > > Try this one > > Sub PasteFormula() > > Dim rngR

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

2013-09-26 Thread rajan verma
e macro > that works upon all sheets at once. > > Regards, > Mukesh Kumar > > > On Thu, Sep 26, 2013 at 3:39 PM, rajan verma wrote: > >> HI Mukesh >> >> i have seen this query many time on this group and another forums, please >> try this macro >&g

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

2013-09-26 Thread rajan verma
the Google 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

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" 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 DB, but facing th

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

2013-09-25 Thread rajan verma
t; 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 http://groups.google.com/group/excel-macros. > For more options

$$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
--- > You received this message because you are subscribed to a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/excel-macros/iCK8rG__1Uw/unsubscribe?hl=en > . > To unsubscribe fr

$$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
o 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 +91 9158998701 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b

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

2013-03-05 Thread rajan verma
end 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 R

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

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

Re: $$Excel-Macros$$ IF Problem

2013-02-08 Thread rajan verma
s@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 +91 9158998701 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ Query

2013-02-08 Thread rajan verma
) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidenti

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

2013-02-07 Thread rajan verma
p 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 http://groups.google.com/group/excel-macros?hl=en. > For more options, visit https://groups.goo

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

2013-02-07 Thread rajan verma
osting is 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$$ Prince Kumar - Most Helpful Member Jan'13

2013-02-02 Thread rajan verma
ps.google.com/group/excel-macros?hl=en. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > -- > 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 @

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, 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 ve

$$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 will not

Re: $$Excel-Macros$$ Certification

2013-01-31 Thread rajan verma
OS" 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 http://groups.google.com/group/excel-macros?hl=en. &

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

2013-01-16 Thread rajan verma
7;" & sh.Name & "'" & "!A1", TextToDisplay:=sh.Name > ActiveCell.Offset(1, 0).Select > End If > Next sh > End Sub > -- Regards Rajan verma +91 9158998701 -- Join official Facebook page of this forum @ https://www.facebo

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 wrote: > Dear Rajan ji, > > Please find attachment & solve , > > thankx > satendra > > > On Fri, Jan 11, 2013 at 1:13 PM, rajan verma wrote: > >> can be done with using c

Re: $$Excel-Macros$$ Conditional Concatenate

2013-01-10 Thread rajan verma
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 post a question in the thread of another member. > 3) Don't post questions

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 wrote: > Dear Prince, > > > Congratulations my friend, well done and keep it up excellent work for our > group. > > > Warm Regards, > Amar &g

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 wrote: > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > -- Regards Rajan verma +91 9158998701

Re: $$Excel-Macros$$ formula

2012-02-27 Thread rajan verma
gt;> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive,

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

2012-01-01 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 threa

Re: $$Excel-Macros$$ Disable delete

2011-12-30 Thread rajan verma
gt; will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > &g

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

2011-12-30 Thread rajan verma
. > > > > 3) Don't post questions regarding breaking or bypassing any security > > measure. > > > > 4) Acknowledge the responses you receive, good or bad. > > > > 5) Cross-promotion of, or links to, forums competitive to this forum in > > signatures are prohibited. > > > > NOTE : Don't ever post personal or c

Re: $$Excel-Macros$$ dob

2011-12-29 Thread rajan verma
sure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Fo

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
otion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > -- > To post to

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

2011-12-14 Thread rajan verma
x27;t ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > -- > To post to this group, send email to excel-macros@googlegrou

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

2011-12-14 Thread rajan verma
tles. 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 post a question in the thread of another member. > > 3) Don't post questions regarding break

Re: $$Excel-Macros$$ Macro work

2011-12-14 Thread rajan verma
ever post personal or confidential data 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 > -- Re

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

2011-12-12 Thread rajan verma
to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ---

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

2011-12-12 Thread rajan verma
ad of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confiden

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

2011-12-11 Thread rajan verma
#x27;t ever post personal or confidential data 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 R

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

2011-12-10 Thread rajan verma
tive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -------

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

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 title

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

2011-12-07 Thread rajan verma
quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of

Re: $$Excel-Macros$$ Formula Help

2011-12-07 Thread rajan verma
gt; > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------ > To post to this group, send

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

2011-12-07 Thread rajan verma
responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not resp

Re: $$Excel-Macros$$ Extract Number In String - EXCEL Formula

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 titles, l

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

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, accur

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

2011-12-06 Thread rajan verma
ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> --**--** >> --**---- >> To post to this group, send

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

2011-12-06 Thread rajan verma
. >> >> I hope this will clarify clear. >> >> Regards, >> >> MARIES. >> +971559828492. >> * >> >> * >> >> >> >> >> >> >> >> On Sun, Dec 4, 2011 at 7:57 PM, rekha siri >> wrote: &g

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

2011-12-06 Thread rajan verma
is forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > ---

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

2011-12-06 Thread rajan verma
Problem, and Need Advice will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses y

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

2011-12-06 Thread rajan verma
;t ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > ------ > To post to this group, send email to excel-macros@googlegr

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

2011-12-04 Thread rajan verma
mpetitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > >

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

2011-12-03 Thread rajan verma
arding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss.

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 wrote: > hi > its a strange problem but hope it will he

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

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)

Re: $$Excel-Macros$$ Indirect Function

2011-12-03 Thread rajan verma
l data 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 >> > > > > -- &g

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

2011-12-03 Thread rajan verma
competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ---

Re: $$Excel-Macros$$ recording macros

2011-12-03 Thread rajan verma
nfidential data 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 R

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

2011-12-03 Thread rajan verma
uestions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook.

Re: $$Excel-Macros$$ fso

2011-12-03 Thread rajan verma
another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. >

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

2011-12-03 Thread rajan verma
kbook. 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

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

2011-12-02 Thread rajan verma
embers 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 post a question in t

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

2011-12-02 Thread rajan verma
ot 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 alr

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

2011-11-27 Thread rajan verma
ost personal or confidential data 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 (934

Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....

2011-11-15 Thread rajan verma
ook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com > > -- > FORUM RULES (934+ memb

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

2011-11-15 Thread rajan verma
t; NOTE : Don't ever post personal or confidential data 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

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

2011-11-11 Thread rajan verma
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 post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses y

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

2011-10-13 Thread rajan verma
> Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Ma

Re: $$Excel-Macros$$ Average

2011-10-13 Thread rajan verma
spot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below lin

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

2011-10-13 Thread rajan verma
gt; > Greg > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.c

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

2011-10-12 Thread rajan verma
lt;><><><><><><><><><><><><><><> > 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
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 wrote: > Dont Use Shapes , use this Code > > ActiveSheet.OLEObjects.Add(classtype:="Forms.Checkbox.1") > > > On

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

2011-10-12 Thread rajan verma
t;).Height) Worksheets(intICounter).Columns(3).ColumnWidth = 16 wksIndex.Hyperlinks.Add shButton, "", "'" & wksIndex.Name & "'!A1", "Click Me", "Index" shButton.TextFrame.Characters.Text =

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

2011-10-12 Thread rajan verma
lt;><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > -- > Some important links for excel users: > 1. Foll

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

2011-10-12 Thread rajan verma
w.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 > > <><><><><><><><><><><><><><><>&l

Re: $$Excel-Macros$$ file browser

2011-10-12 Thread rajan verma
gt;<><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Regards Rajan verma +91 9158998701 -- ---

Re: $$Excel-Macros$$

2011-10-10 Thread rajan verma
gt; > 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 wrote: > > hi > > See the a

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

2011-10-08 Thread rajan verma
st follow below link >>http://www.facebook.com/discussexcel >> >> >> > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > ht

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

2011-10-05 Thread rajan verma
ChilExcel wrote: > Thanks Rajan I need is to columns B and C (together) > containing the mirrored pair in same row > good solution you propose, but only in column B duplicate > > Thanks Rajan > > 2011/10/4 rajan verma > >> Try this Code : >> this Code

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

2011-10-05 Thread rajan verma
ttp://www.excel-macros.blogspot.com > 4. Learn VBA Macros 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 > > <><><><>&l

Re: $$Excel-Macros$$ Need Help

2011-10-05 Thread rajan verma
his group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > --

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

2011-10-04 Thread rajan verma
. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><&

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

2011-10-04 Thread rajan verma
t; 4. Learn VBA Macros 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 > > <><

  1   2   3   >