Re: $$Excel-Macros$$ Run time error...

I see..instead of ff.select use r.select On Mon, Feb 9, 2015 at 4:51 PM, Christos Alekopoulos < christosalekopou...@gmail.com> wrote: > Thank you for the quick response!!! > > It seems that now I get the same error in the ff.select line. > > I tried also to change the line and combine it with th

Re: $$Excel-Macros$$ Run time error...

Thank you for the quick response!!! It seems that now I get the same error in the ff.select line. I tried also to change the line and combine it with the line above i.e. ff=r.Address.Select . I don't get an error but the macro doesn't seem to be doing anything at all. Thank you again for th

Re: $$Excel-Macros$$ Run time error...

Hi Replace that line with below two: ff.Select ActiveCell.replace What:=Search, Replacement:=Replacement, LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Cheers!! On Mon, Feb 9, 2015 at 3:48 PM, Christos Alekopoulos < ch

Re: $$Excel-Macros$$ Run Time Error after PC becomes idle

thanks Paul. i reinstalled windows and and its seems to be ok at least for now On Sat, Jan 24, 2015 at 1:57 PM, Paul Schreiner wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (schreiner_p...@att.net) Add cleanup rule >

Re: $$Excel-Macros$$ Run Time Error after PC becomes idle

does the userform initialize event macro rely on access to a network drive? sometimes, these "close" when not in use and automatically "wake up". I'd put a breakpoint in the initialize macro and step through to see what statement is causing the error. Unfortunately, with userforms, when an err

Re: $$Excel-Macros$$ run-time error '1004': Reference is not valid.

First of all, if you saved it as a "macro enabled workbook file", that means you saved it as a .xlsm file. If so, they could NOT have opened the file with a version of Excel prior to 2010. So, that just leaves a "newer" version, which I wouldn't jump to immediately.   Which line is showing the err

Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

I m still not clear, can you explain 1st line of Input and how you derived result. On Thu, Jun 12, 2014 at 1:34 AM, Will Sob wrote: > Hi Joshi, > > this is my data > 7 9 18 24 39 40 4 18 26 32 36 40 45 21 10 31 35 40 41 44 46 2 5 9 28 > 29 48 36 10 19 20 33 45 46 25 15 26 29 35 36 41 19

Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

Hi Joshi, this is my data 7 9 18 24 39 40 4 18 26 32 36 40 45 21 10 31 35 40 41 44 46 2 5 9 28 29 48 36 10 19 20 33 45 46 25 15 26 29 35 36 41 19 3 5 8 10 16 17 46 16 17 22 38 44 49 14 1 7 9 27 30 48 28 9 25 34 37 44 45 6 17 22 23 33 36 42 12 16 18 29 34 35 39 40 13 20 31 34 36 44 11

Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

hi can you illustrate an example.. we can help you on that.. Cheers!! On Wed, Jun 11, 2014 at 2:17 AM, Will Sob wrote: > thanks it did work but it did not build the triplets i specify > > it just calculated it to 18424 > > > On Tue, Jun 10, 2014 at 6:19 AM, Vaibhav Joshi wrote: > >> Here you

Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

thanks it did work but it did not build the triplets i specify it just calculated it to 18424 On Tue, Jun 10, 2014 at 6:19 AM, Vaibhav Joshi wrote: > Here you are declaring Dim tbl(1 To ntbl, 1 To 2) As Long > > when vale of m drops belwo 1 you will get error 9 > > change lines to.. > > Dim tb

Re: $$Excel-Macros$$ Run time error 9 subscript out of range - lotto Query

Here you are declaring Dim tbl(1 To ntbl, 1 To 2) As Long when vale of m drops belwo 1 you will get error 9 change lines to.. Dim tbl(0 To ntbl, 1 To 2) As Long can comment whether this will work without your sample data. Cheers!! On Tue, Jun 10, 2014 at 10:41 AM, Vaibhav Joshi wrote: > He

Re: $$Excel-Macros$$ run time error 9 subscript out of range

Dear Expert, Please look at this code what is wrong with it I'm not an expert in VBA but would need some of your knowledge in this matter I want to put together a formula that takes say a 6/49 lotto and point out say I want to find the most occurring triples, it finds them and show how many times

Re: $$Excel-Macros$$ run time error 9 subscript out of range

Hi change line to LastRow = Workbooks("Quantum R-Creator.xlsm").Worksheets("Dump").Range("E1048576").End(xlUp).Row + 1 If you include workbook name then you need to also add file extension too. Cheers!! On Mon, Jun 9, 2014 at 11:07 PM, Secret Shot wrote: > Dear Expert, > > I am working on a

Re: $$Excel-Macros$$ Run time error - Type mismatch

Vaibhav, before giving a solution, it is always a kind thing to do to ensure you validate what you are saying. If the Applications Extensibility library reference wasn't added, the sub-routine wouldn't have even execute because the declaration in the following lines would have not compiled. Dim Sr

Re: $$Excel-Macros$$ Run time error - Type mismatch

Hi Check reference is given to Microsoft Visual Basic for Applications Extensibility 5.x" Thanks On Mon, Apr 28, 2014 at 5:50 AM, Sam Mathai Chacko wrote: > Ondrej, for that you'll have to enable programmatic access to VBA. Just > search the internet how to do that, or post back. Someone will h

Re: $$Excel-Macros$$ Run time error - Type mismatch

Ondrej, for that you'll have to enable programmatic access to VBA. Just search the internet how to do that, or post back. Someone will help you. Regards, Sam Mathai Chacko On Apr 27, 2014 7:49 PM, "Ondrej" wrote: > HI buddies > there is an error in the last sequence of this code (bold), and I ca

Re: $$Excel-Macros$$ Run time error '1004' Method "Range " of oblect '_Globle fails

I'm not sure what the purpose of your macro is.   It LOOKS like ComboBox1 has: "CAP, CREAM, DROP". You're trying to select from one of these values in the combobox and load another list (pre_Med_Name_1)   But there's a couple of things wrong with this approach. First, the Range() object only has a

Re: $$Excel-Macros$$ Run time error '1004' Method "Range " of oblect '_Globle fails

Dear Rupesh, Kindly share the workbook with us. Warm Regards, Gawli Anil On Thu, Jan 2, 2014 at 1:37 PM, Rupesh Patil wrote: > Hi expert > > Please look below code and tell me why I am getting this error(Mentions in > subject line) > Private Sub ComboBox1_Click() > Select Case ComboBox1

Re: $$Excel-Macros$$ Run time error 5 - invalid procedure code or arguement

try this webquery Sub Macro1() For i = 1 To 3 Sheets.Add after:=Sheets(Sheets.Count) With ActiveSheet.QueryTables.Add(Connection:= _ "URL;" & Sheets("states").Range("a" & i).Value, Destination:=Range( _ "$A$1")) .Name = i .FieldNa

Re: $$Excel-Macros$$ Run-Time Error 3170

try below code: Between cdate('01/08/2012') And cdate('31/08/2012')" regards, swapnil. On Wed, Sep 26, 2012 at 2:03 PM, wirelesscellularguy < wirelesscellular...@gmail.com> wrote: > Hi Swapnil, > > With slight modification of the code, i could now pass the Start Date and > the End Date > >

Re: $$Excel-Macros$$ Run-Time Error 3170

Hi Swapnil, With slight modification of the code, i could now pass the Start Date and the End Date Regards, Wireless On Friday, September 14, 2012 1:45:41 PM UTC+5:30, Swapnil Palande wrote: > > Hi, > > I don't know exact reason for above error, because when I try to execute > code it is giv

Re: $$Excel-Macros$$ Run-Time Error 3170

Hi Swapnil, Thanks for the corrections. I implemented them. I again need your help to pass the Start Date and End Date from the excel to Access Query(as we did for Enter Date & Enter Cell, before). In the Criteria, I entered "Between [Start Date] And [End Date]" but couldn't figure out what th

Re: $$Excel-Macros$$ Run-Time Error 3170

Hi, Pls you provide sample files. Regards, Swapnil. On Thu, Sep 13, 2012 at 11:03 PM, wirelesscellularguy < wirelesscellular...@gmail.com> wrote: > Hi All, > > I am trying to query my Access Database(Database1.accdb) through vba. > I am getting run-time error 3170 at the highlighted line. > >

Re: $$Excel-Macros$$ Run-time error popup message

Hi Lalit, Please see my previous mail attachment of run time error popup message file and in this i have facing some daily basis macro timings problems. You have resolved the query but now i can't able to macro timings properly. please do the needful and i sent too many mails to the group no buddy

Re: $$Excel-Macros$$ Run-time error popup message

Hello Noorain & Rajan, Please help me, my query is still not yet resolved. please provide me the solution. Regards Lokesh M On Thu, Aug 16, 2012 at 6:19 PM, Lokesh Loki wrote: > Hi Experts, > > May i know the reason why my query has been not yet resolved? Any think > you want information from m

Re: $$Excel-Macros$$ Run-time error popup message

Hi Experts, May i know the reason why my query has been not yet resolved? Any think you want information from my side or what? I am sending again and again requests to the experts please resolve it but no buddy is replying. Please let me know the reason. Thanks Lokesh.M On Sun, Aug 12, 2012 at 9

Re: $$Excel-Macros$$ Run time error "out of memory 7"

Hi Prince Is there any reason not to think that an "Out of memory" message mens that the computer is out of memory. There are a number of possible causes which could include: Not enough physical memory Too many other programs running Not enough disk space for paging memory A program (not necessa

Re: $$Excel-Macros$$ Run-time error popup message

Hi Experts, Please resolve my small query from past 2 weeks i am requesting to the group to resolve it but till no buddy is replying to me. The query is almost finishing stage but it's not fully resolved getting some mismatch macro timings. So please response to my query. Being a member of group

Re: $$Excel-Macros$$ Run-time error popup message

n verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* Rajan_Verma [mailto:rajanverma1...@gmail.com] > *Sent:* 04 August 2012 4:12 > *To:* 'excel-macros@googlegroups.com' > *Subject:* RE: $$Excel-Macros$$ Run-time error popup message > > ** ** > > *Re

RE: $$Excel-Macros$$ Run-time error popup message

Also use this format [h]:mm:ss Regards Rajan verma +91 7838100659 [IM-Gtalk] From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: 07 August 2012 9:06 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Run-time error popup message Replace this one

RE: $$Excel-Macros$$ Run-time error popup message

100659 [IM-Gtalk] From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: 04 August 2012 4:12 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Run-time error popup message Replace error line with this : .Offset(lngCellLoop, 1).Value = Format(CDate(.Offset(lngCell

Re: $$Excel-Macros$$ Run-time error popup message

I didn't understand your remaining 50% query. Exactly what u want and how? Pl elaborate it... Regards, Gawli Anil On Mon, Aug 6, 2012 at 2:25 PM, Lokesh Loki <> wrote: > Hi All, > > It's urgent anybody please resolve my query. I hope all of you understand > my concern. > > Regards > Lokesh.M > >

Re: $$Excel-Macros$$ Run-time error popup message

Hi All, It's urgent anybody please resolve my query. I hope all of you understand my concern. Regards Lokesh.M On Mon, Aug 6, 2012 at 11:18 AM, Lokesh Loki wrote: > Hi All, > > From last week to till now i am sending mails to the group but till now i > did not get any reply from the group. Only

Re: $$Excel-Macros$$ Run-time error popup message

Hi All, >From last week to till now i am sending mails to the group but till now i did not get any reply from the group. Only rajan has replied to my mail but 50% of the problem has been resolved and remaining still i am facing issue on VBA code. So team please resolve the vba code it would be ver

Re: $$Excel-Macros$$ Run-time error popup message

Hi Rajan, I have replaced the error line and i got the exact employee's number of working days, but the 4 hrs of macro timings are not multiplied to those users. Please check and do the needful brother. Regards Lokesh.M On Sat, Aug 4, 2012 at 4:11 PM, Rajan_Verma wrote: > *Replace error line wi

RE: $$Excel-Macros$$ Run-time error popup message

Replace error line with this : .Offset(lngCellLoop, 1).Value = Format(CDate(.Offset(lngCellLoop, -1).Value + (4 * objDic.Count)), "hh:mm:ss") Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of lok

Re: $$Excel-Macros$$ Run-time error popup message

Hi Experts, Any buddy please resolve this query because of i need as soon as possible. Regards Lokesh.M On Sat, Aug 4, 2012 at 6:48 AM, Lokesh Loki wrote: > Hi All, > > Still i am not getting reply from the experts. Please do the needful. > > Regards > Lokesh.M > > > On Thu, Aug 2, 2012 at 5:5

Re: $$Excel-Macros$$ Run-time error popup message

Hi All, Still i am not getting reply from the experts. Please do the needful. Regards Lokesh.M On Thu, Aug 2, 2012 at 5:59 PM, lokesh wrote: > Hi All, > > > > When I am clicked the Get Report to know monthly report I got the error > popup message window saying that “Run-time error’1

Re: $$Excel-Macros$$ Run-time error message: Method 'Hidden' of object 'Range' failed

Send ME to MY email your file with my macro and this msg Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Anil Pandit Sent: Friday, March 30, 2012 5:48 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Run-time error message: Method 'Hidde

Re: $$Excel-Macros$$ Run-time error message: Method 'Hidden' of object 'Range' failed

Another point I wanted to note is that, when I remove the setting: Application.ScreenUpdating = False, Excel looks like it is in some kind of perpetual loop or at least going through a high level of CPU cycles before it crashes. Regards, Anil On Friday, March 30, 2012 11:48:10 AM UTC+1, Anil

Re: $$Excel-Macros$$ Run-time error message: Method 'Hidden' of object 'Range' failed

Thanks for the reply Don. I'm still getting the same Run-time error and then an Excel crash. The debug points to the line: "Columns.Hidden = False", stating: ""Run-time error message: Method 'Hidden' of object 'Range' failed." I created a sub-procedure to display a MsgBox with the value of Co

Re: $$Excel-Macros$$ Run-time error message: Method 'Hidden' of object 'Range' failed

'Assumes this in DV list 'DC36U 'DC44U 'AC42U Private Sub Worksheet_Change(ByVal Target As Range) Dim DC36U As String Dim DC44U As String Dim AC42U As String '??DC36U = "Tekelec Eagle XG 870-3040-06 (DC)" '??DC44U = "Tekelec Eagle XG 870-3068-06 (DC)" '??AC42U = "Teke

Re: $$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)

1.. Sub Macro1() Dim sFile As String sFile = "S:\Office Documents\Purchase Orders\" & ActiveSheet.Range("F5").Text & ".pdf" If Len(Dir(sFile)) Then If MsgBox("Purchase order number already used, Verify and correct purchase order number", vbOKOnly) = vbOK Then Exit Sub

Re: $$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)

Thanks a lot! Works perfectly! -- 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

Re: $$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)

Dear Rikiko, Please use this one.. *Sub ExportPDF() Sheets(1).Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="\Sales.pdf", Quality:=xlQualityStandard, OpenAfterPublish:=True End Sub * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Run-time error 1004 when no file selected

after u declare variables use on error goto abc and before end sub abc: exit sub use error handlers http://www.xlpert.com/partG.htm http://www.functionx.com/vbaexcel/Lesson26.htm On Thu, Auon errg 11, 2011 at 1:16 PM, Andy McGooner < andrew_mcni...@yahoo.co.uk> wrote: > Hi All, > > I hav

Re: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of Range class failed

What does you code look like where you copy a cell (or range of cells) from the source? Thanks David On Dec 1, 8:01 am, excelCPA wrote: > I have tried recording it manually using a macro as Dave suggested and > the code Deepak suggested with no luck. > > Here's the weird part, if the source is a

Re: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of Range class failed

I have tried recording it manually using a macro as Dave suggested and the code Deepak suggested with no luck. Here's the weird part, if the source is anything other than another Excel workbook, the past special code works fine. For example if I copy something out of Word, IE, Outlook, or even th

Re: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of Range class failed

Hi, Please try this code, Hope this will help. Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Regards, Deepak Rai On Tue, Dec 1, 2009 at 10:03 AM, Dave Bonallack wrote: > Hi, > Try doing it manually with the macro recorder on, the

RE: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of Range class failed

Hi, Try doing it manually with the macro recorder on, then look at the syntax. Dave. > Date: Mon, 30 Nov 2009 10:05:31 -0800 > Subject: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of Range > class failed > From: jon.wester...@gmail.com > To: excel-macros@googlegroups.com > >