Re: $$Excel-Macros$$ how to get month Occurrence in no.
try this.. Function convertMonthName2Number(monthName As String) As Integer ' try to convert month name to actual date type Dim dtestr As String dtestr = monthName & "/1/2000" Dim dte As Date On Error Resume Next dte = CDate(dtestr) If Err.Number <> 0 Then convertMonthName2Number = -999 Exit Function End If On Error GoTo 0 convertMonthName2Number = Month(dte) End Function OR you can refer this :- http://www.codeforexcelandoutlook.com/blog/2009/04/converting-month-name-to-number/ Regards, Manoj On Tue, Dec 28, 2010 at 12:26 PM, Rohan Young wrote: > Hi experts, > > is there any formula, if i only type in cell April and the other cell > return the value 4, remember if i type simply April not 04/01/2010 etc. etc. > > please provide your feedback > > > thanks & regards > > ROHAN > 9818247278, 8860567680 > > -- > > -- > 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 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Nested IF functions?
i dont understand what u mean exactly but i will jus tell u abt nested if in excel. let me know if you wanna know nesed if for Macro. it is if else function. so write if and give some value if is its true and in place of else write another if. if you wanna know the syntax refer help in excel. just type in IF and you will get everything there. e.g. =IF(A3=3,"Equal",IF(A3<3,"Less",IF(A3>3,"Greater"))) explaination if A3 = 3 value wil be "Equal" if A3<3 then value will be "Less" if A3<3 then value will be "Greater" - Original Message > From: J D > To: MS EXCEL AND VBA MACROS > Sent: Tue, 28 December, 2010 7:36:57 AM > Subject: $$Excel-Macros$$ Nested IF functions? > > I am a concrete estimator who is trying to create some cut and paste > Estimate line items I can just grab from one spread sheet and paste in > to my estimate. > > I was refining one and tried to use the IF function to pick the number > of labor hours based on sq footage. More s.f. and we are more > productive therefore less hours per s.f. > > I was trying to say if less that 500 s.f. then .035 hrs/s.f. 500 to > 1,000 then .0275 hrs/s.f. >1,000 s.f. then .0225 hours/s.f. > > I could get one working but wanted to know how to get more going > choises out of one formula. Attached is the assembly and the formula > below it. > > > Form, place and finish ~ (__) s.f. of 4" broom swept finish concrete > sidewalk. Concrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/ > w1.4 wwf. $4,410.00 > Area990 s.f.Perimeter114 l.f. > Concrete9900.33 1.03336.50112.463 131451885 > Labor 130.45.2 5.240 208 > wwf99040 24.75 257175 > 2" SB 9900.26257.4 260 0.49127.4 > Labor990 0.0032.97 340 120 > Poly9901800 0.55 0.68551 > Labor 9900.0021.98 240 80 > Expansion9900.25 247.51002.475 2.531.6479.1 > Labor 2500.012.5 2.540 100 > Curing640350 1.82857142950.365714286 0.45522 > Labor 9900.0032.97 340 120 > 2 x 411416 7.125 85.8146.48 > Labor 1140.3337.62 0.27.5247.6 40304 > Finish990 1009.92.75 27.22527.340 1092 > > > > 4409.98 > =IF(B16<500,3.5,2.75) > > -- >-- >- > 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 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ how to get month Occurrence in no.
other stuff =MONTH(DATEVALUE("1 "&A1&" 2010")) On Tue, Dec 28, 2010 at 3:34 PM, siti Vi wrote: > If the word "April" or *another month name *is type correctly in cell A1 > try this formula in B1 > > =TEXT(DATEVALUE("1 "&A1&" 2010"),"M") > > > > > On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young wrote: > >> Hi experts, >> >> is there any formula, if i only type in cell April and the other cell >> return the value 4, remember if i type simply April not 04/01/2010 etc. etc. >> >> please provide your feedback >> >> thanks & regards >> >> ROHAN >> 9818247278, 8860567680 >> >> >> > -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ how to get month Occurrence in no.
If the word "April" or *another month name *is type correctly in cell A1 try this formula in B1 =TEXT(DATEVALUE("1 "&A1&" 2010"),"M") On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young wrote: > Hi experts, > > is there any formula, if i only type in cell April and the other cell > return the value 4, remember if i type simply April not 04/01/2010 etc. etc. > > please provide your feedback > > thanks & regards > > ROHAN > 9818247278, 8860567680 > > > -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
RE: $$Excel-Macros$$ how to get month Occurrence in no.
Hi, A shorter version would be: =MONTH(--(1&A1)) This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended abbreviations (eg Sept) and also unabbreviated (eg June, November) Regards - Dave. Date: Tue, 28 Dec 2010 15:34:01 +0700 Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no. From: villager.g...@gmail.com To: excel-macros@googlegroups.com If the word "April" or another month name is type correctly in cell A1 try this formula in B1 =TEXT(DATEVALUE("1 "&A1&" 2010"),"M") On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young wrote: Hi experts, is there any formula, if i only type in cell April and the other cell return the value 4, remember if i type simply April not 04/01/2010 etc. etc. please provide your feedback thanks & regards ROHAN 9818247278, 8860567680 -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ how to get month Occurrence in no.
Impressive ..!! Good show Dave, Siti, STDEV :) Best Regards, DILIPandey On Tue, Dec 28, 2010 at 4:13 PM, Dave Bonallack wrote: > Hi, > A shorter version would be: > =MONTH(--(1&A1)) > This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended > abbreviations (eg Sept) and also unabbreviated (eg June, November) > Regards - Dave. > > -- > Date: Tue, 28 Dec 2010 15:34:01 +0700 > Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no. > From: villager.g...@gmail.com > To: excel-macros@googlegroups.com > > > If the word "April" or *another month name *is type correctly in cell A1 > try this formula in B1 > > =TEXT(DATEVALUE("1 "&A1&" 2010"),"M") > > > > On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young wrote: > > Hi experts, > > is there any formula, if i only type in cell April and the other cell > return the value 4, remember if i type simply April not 04/01/2010 etc. etc. > > please provide your feedback > > thanks & regards > > ROHAN > 9818247278, 8860567680 > > > > > -- > > -- > 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 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > > -- > 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 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
RE: $$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One Column
Hi, Try : Sub test2() Dim Col As Integer, c As Range, Line As Long Dim inCalculationMode As Integer Application.ScreenUpdating = False inCalculationMode = Application.Calculation Application.Calculation = xlCalculationManual Col = Cells(1, Columns.Count).End(xlToLeft).Column Line = Cells(Cells.Rows.Count, 1).End(xlUp).Row + 1 For i = 2 To Col Range(Cells(1, i), Cells(Cells.Rows.Count, i).End(xlUp)).Copy _ Cells(Line, 1) Line = Cells(Cells.Rows.Count, 1).End(xlUp).Row + 1 Next i Application.Calculation = inCalculationMode Application.ScreenUpdating = True End Sub Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Financeguy Envoyé : dimanche 26 décembre 2010 00:30 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One Column Hi, I'm trying to select one range at a time for each individual column within a single worksheet. I have range data in approximately 150 columns on the worksheet that I would like to sort individually (ascending order), then cut, and finally paste into the last row of Column A. For example, if I had data on a sheet, like A1:A13000, B1:B1453, C1:C1232...and so on... till say CC1:CC1535I'd like to cut each rangeB1:B14535, and paste it below A13000.and so on.. It is cumbersome to do it manually, and I would love some VBA code that could help me with accomplish this. Many thanks in advance, Finance guy -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
RE: $$Excel-Macros$$ Amount Format
Please, see attached file. Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Rajiv Kumar Envoyé : lundi 20 décembre 2010 15:11 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Amount Format Dear sir how can I write excel sheet dis format 1,85,000 in excel. It yes then please give me tips. Awating your positive replay… Raj -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts Number Format.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Nested IF functions?
Hi J D, It would be really appreciable if you can share a test file on this. Help us to help you :) Best Regards, DILIPandey On Tue, Dec 28, 2010 at 7:36 AM, J D wrote: > I am a concrete estimator who is trying to create some cut and paste > Estimate line items I can just grab from one spread sheet and paste in > to my estimate. > > I was refining one and tried to use the IF function to pick the number > of labor hours based on sq footage. More s.f. and we are more > productive therefore less hours per s.f. > > I was trying to say if less that 500 s.f. then .035 hrs/s.f. 500 to > 1,000 then .0275 hrs/s.f. >1,000 s.f. then .0225 hours/s.f. > > I could get one working but wanted to know how to get more going > choises out of one formula. Attached is the assembly and the formula > below it. > > > Form, place and finish ~ (__) s.f. of 4" broom swept finish concrete > sidewalk. Concrete to be 3,500 psi and reinforced with 6 x 6 , w1.4/ > w1.4 wwf. > $4,410.00 >Area990 s.f.Perimeter 114 l.f. > Concrete990 0.331.03336.501 12.463 13 145 > 1885 > Labor 13 0.4 5.2 5.2 40 208 > wwf 990 40 24.75 25 7 175 > 2" SB 990 0.26257.4 260 0.49127.4 > Labor 990 0.003 2.973 40 120 > Poly990 18000.550.6 85 51 > Labor 990 0.002 1.982 40 80 > Expansion 990 0.25247.5 100 2.475 2.5 31.64 > 79.1 > Labor 250 0.012.5 2.5 40 100 > Curing 640 350 1.828571429 5 0.365714286 0.4 55 > 22 > Labor 990 0.003 2.973 40 120 > 2 x 4 114 16 7.125 8 5.8146.48 > Labor 114 0.3337.62 0.2 7.524 7.6 40 304 > Finish 990 100 9.9 2.7527.225 27.340 1092 > > > >4409.98 > =IF(B16<500,3.5,2.75) > > -- > > -- > 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 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
RE: $$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One Column
I forgot to sort the columns : Sub test2() Dim Col As Integer, c As Range, Line As Long Dim inCalculationMode As Integer Application.ScreenUpdating = False inCalculationMode = Application.Calculation Application.Calculation = xlCalculationManual Col = Cells(1, Columns.Count).End(xlToLeft).Column Line = Cells(Cells.Rows.Count, 1).End(xlUp).Row + 1 Set rg = Range(Cells(1, 1), Cells(Cells.Rows.Count, 1).End(xlUp)) rg.Sort key1:=rg(1, 1), order1:=xlAscending For i = 2 To Col Set rg = Range(Cells(1, i), Cells(Cells.Rows.Count, i).End(xlUp)) rg.Sort key1:=rg(1, 1), order1:=xlAscending rg.Copy Cells(Line, 1) Line = Cells(Cells.Rows.Count, 1).End(xlUp).Row + 1 Next i Application.Calculation = inCalculationMode Application.ScreenUpdating = True End Sub Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Financeguy Envoyé : dimanche 26 décembre 2010 00:30 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One Column Hi, I'm trying to select one range at a time for each individual column within a single worksheet. I have range data in approximately 150 columns on the worksheet that I would like to sort individually (ascending order), then cut, and finally paste into the last row of Column A. For example, if I had data on a sheet, like A1:A13000, B1:B1453, C1:C1232...and so on... till say CC1:CC1535I'd like to cut each rangeB1:B14535, and paste it below A13000.and so on.. It is cumbersome to do it manually, and I would love some VBA code that could help me with accomplish this. Many thanks in advance, Finance guy -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
RE: $$Excel-Macros$$ Macro security help
Hello, 2. If ActiveCell.HasFormula Then msgbox "The active cell contains a formula" End If Regards. Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de hanumant shinde Envoyé : samedi 18 décembre 2010 22:00 À : Excel Group Objet : $$Excel-Macros$$ Macro security help hey guys i think this must tough. 1. is there any functionality through which i can get to know if anybody has done Alt +F11 i.e. edit on my macro. 2. how can i get to know if a specific /cells have formula or value? thanks, hanumant -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- -- 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 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts