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

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

Hi All, I have created this code that finds a value, then changes any pre-set value into a new value determined by the user as well. The problem is that I get an "error 424" and a message item required every time I run it. I have highlighted the line where it seems to have the error. The code

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

> > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > --------

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

e people you can, As long as ever you can.” - John Wesley - > > From: Hilary Lomotey >To: excel-macros >Sent: Saturday, January 24, 2015 10:16 AM >Subject: $$Excel-Macros$$ Run Time Error after PC becomes

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

Hello Experts, please kindly advice, i have written a programme, but anytime i leave the pc to be idle for like say 5 minutes if i open a userform, i get a runtime error 1004 and error 75. please what is happening. kindly advice. thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y

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

er you can.” - John Wesley --------- From: deanalt via MS EXCEL AND VBA MACROS >To: excel-macros@googlegroups.com >Sent: Friday, July 18, 2014 9:18 PM >Subject: $$Excel-Macros$$ run-time error '1004': Reference is not valid. > > >

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

I sent someone an EXCEL macro enabled workbook file (created in EXCEL 2010) and they ran some macros, saved the result, then later tried to run a different macro and got the error message in the subject line. I had no such problem in running it just the way they did it on my computer. It is

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

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

Hey Will Welcome! You need to start new thread as per forum rule so that you get attention & proper resolution of your solution.. Did this code worked proper;y previously ? Cheers!! On Tue, Jun 10, 2014 at 1:24 AM, Will Sob wrote: > Dear Expert, > > Please look at this code what is wrong wi

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

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

HI buddies there is an error in the last sequence of this code (bold), and I can not find the reason why please help Sub btn_vytvorit_Click() Dim ws As Worksheet Dim wsName As String, Name As String Dim MsgError As String Dim wsCopyFrom As Worksheet Set wsCopyFrom = Worksheets("vzorovy_zapis") Di

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

l the times you can, To all the people you can, As long as ever you can.” - John Wesley - > > From: Rupesh Patil >To: excel-macros@googlegroups.com >Sent: Thursday, January 2, 2014 3:07 AM >Subject: $$Excel-Mac

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

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

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 Case "CAP" pre_Med_Name_1.List = Range("CAP").Value Case "CREAM" pre_Med_Name_1.List = Range("CREAM").Value Case

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

$$Excel-Macros$$ Run time error 6

Hi, While running macro am getting run time error 6 as shown in the attached file. I am using huge data which contains 9 rows. Could you please let me know how to run macro with hugre data. Thanks, Chandra -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME

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

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

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. Sub GetData() Dim MyDatabase As DAO.Database Dim MyQueryDef As DAO.QueryDef Dim MyRecordset As DAO.Recordset Dim i As Integer Set MyDatabase = DBEngine.OpenD

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

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

Hi Group, I have a project which is running fine on my system with XP OS but the same project giving error of "Out of Memory 7" on other system with XP platform. I am using VBA and Acess as data source. I tried my level best to track the source of error but not able to find it.So can you pls

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

set(lngCellLoop, 1).Value = Format(CDate(.Offset(lngCellLoop, >>>> -1).Value + (4 * objDic.Count)), "hh:mm:ss")* >>>> >>>> * * >>>> >>>> * * >>>> >>>> * * >>>> >>>> *Regards* >>>>

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

CellLoop, >>> -1).Value + (4 * objDic.Count)), "hh:mm:ss")* >>> >>> * * >>> >>> * * >>> >>> * * >>> >>> *Regards* >>> >>> *Rajan verma* >>> >>> *+91 7838100659 [IM-Gtalk

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

t(CDate(.Offset(lngCellLoop, >> -1).Value + (4 * objDic.Count)), "hh:mm:ss")* >> >> * * >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-macros@googlegr

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

> * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *lokesh > *Sent:* 02 August 2012 5:59 > *To:* excel-macros@googlegroups.com > > *Subject:* $$Excel-Macros$$ Run-time error popup message > > ** ** > &g

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

Behalf Of lokesh Sent: 02 August 2012 5:59 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Run-time error popup message 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'13 in VBA'&q

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

lse >> Range("C5") = "DC" >> Select Case Target >>Case "DC36U" >> Columns("G:L").Hidden = True >>Case "DC44U" >> Range("E1:G1,J1:l1").EntireColumn.Hidden = True >>Case &quo

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

Range("E1:G1,J1:l1").EntireColumn.Hidden = True >Case "AC42U" > Columns("E:J").EntireColumn.Hidden = True > Range("C5") = "AC" > End Select > Application.ScreenUpdating = True > End Sub > > Don Guillett > Mic

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

ct Application.ScreenUpdating = True End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Anil Pandit Sent: Wednesday, March 28, 2012 11:04 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Run-time error message: Method 'Hidden' of object

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

Hi, I'm new to VBA and I'm posting this because I've been tearing my hair out over this all day, so I hope someone has seen this before and can point me in the right direction. I have created a worksheet change event which hides some columns according to a string that is chosen from a list in

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

penAfterPublish:=True, _ Quality:=xlQualityStandard, _ IncludeDocProperties:=True, _ IgnorePrintAreas:=False End SubModify above to fit your need Don Guillett SalesAid Software dguille...@gmail.com From: Rikiko Sent: Thursday, December 08, 2011 4:14 AM To: excel-macros@googlegroups.com S

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/*

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

I'm getting a run-time error '424': Object required for the following code: Sub ExportPDF() Sheets("OOF2_EIF").Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=“sales.pdf”, Quality:=xlQualityStandard, OpenAfterPublish:=True End Sub Help would be greatly app

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

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

Hi All, I have a spreadsheet that stores data from a text file, the idea being that it opens the file dialog and i select the relevant text file. The problem is that when i do the file open and press cancel i get the folowing message: Run-time error '1004' false.xls could not be found How do i

$$Excel-Macros$$ Run time error '13'... Type mismatch error

Hi I am getting following error while running below mention code. Please help. [cid:image001.png@01CC2B7B.1B6C0EA0] Dim nrow As Long ActiveCell.Select Cells(8, 1).Select ActiveCell.Offset(1, 0).Range("A1").Select Range(Selection, Selection.End(xlDown)).Select nrow = Range(Selection, Selecti

$$Excel-Macros$$ Run time error 1004

The following macro should activate worksheet Matrix Table then print out some text and then print out the values in the Nstep_tran array. Since I don't have a row counter, I am in the process of working out the formula for the Else case. What follows Else is a place holder. I cannot get the init

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

=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, then look at the syntax. > > > Dave. > > > > > Da

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

alse, 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, then look at the syntax. > > Dave. > > > > Dat

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

der 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 > &

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: exce

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

This is something that seems pretty simple, I am trying to paste values into a workbook using a macro: Range("A1").Select Selection.PasteSpecial Paste:=xlPasteValues I start out by manually copying a range of cells in a separate workbook and clicking a form button to paste the values. Each time

$$Excel-Macros$$ Run Time Error 3050 - Could Not Lock File - ERROR?

Hi All, Does anyone know why this error occurs? I am using DAO in a Excel Userform to save data in MS Access. Approx 40 users are using the userform and its working fine however sometimes it shows following error message and crashes: Run Time Error 3050 - Could Not Lock File What could be the r

$$Excel-Macros$$ run time ERROR 9

Dear All I am having vba code not written by me but one of my friend.Now I am facing a problem while running the same. This I am using to make a monthly report ,this programe open a indivisual file from the given folsder and copy paste required data in given excel sheet. Now when I am try

$$Excel-Macros$$ Run-time error '-2147352571 (80020005) - Type Mismatch

Hi, I am trying to populate an excel userform combo box from a table in access database using DAO. When I pass arguments as following: AddItemtoDropDownList Me.cboUserName, "LookupLists", "UserId" VBA returns following error:  === Run-time error '-2147352571 (80020005) Type M