Hello to all,
I have the following specific problem. I want the following working Excel Spreadsheet formula incorporated into a VBA makro code:
=INDEX('I:\CDS_Bewertungsk
I tried
Cells(58, 4).Value = Application.WorksheetFunct
Sheets("main").Range("A1:Z
Workbooks("I:\CDS_Bewertun
False))
It doesn't work. It gives me the following error: Run-time error '9': Subscript out o range. I think it has sth to do with specifying the Range("*") or accessing the other workbook to index/match the data.
Thanks for your help. I guess it is just about getting the correct synthax.
cy
michael
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi,
no the other sheet is not open. At least I think so. Probably sb else has access to this file. I will copy the file to another place and try it again.
No it doesn't work. I guess it has sth to do with Workbooks("I:\CDS_Bewertun
Do you know any synthax that works? It would help me soooo much :).
I need this code since I want to match values in one sheet with another sheet that are not equal but similar . So I later need to write a function IsLike.Sub IsLike()
Dim dValue As Double
Dim sTxt As String, sEuro As String, sLike As String
dValue = 23.21
sEuro = "Miauu"
sLike = "*" & sEuro & "*"
sTxt = Range("B11").Value
If sTxt Like sLike Then
MsgBox "Im String enthalten!"
Else
MsgBox "Nicht im String enthalten!"
End If
End Sub
------------------------
VBA is such a stupid language...you spend hours and hours searching for damn synthax problems for things which are so obvious and logically easy. I am enjoying myself much more when all data are in excel and I can just put them into R-project for intersting analysis.
Thx for your help. I will stick with the code I have and try to get the identifiers to be the same. I guess that's easier. I don't want to open the source excel file since it's really big and not very stable. Moreover I would need to extract only the first sheet without the makros, put it somewhere else, make my match/index staff, delete the sheet and do everything without screen updating. This is an incredible bug in excel vba.....
You saved me a lot of time trying and trying again to change some stupid synthax.
cy
michael
Business Accounts
Answer for Membership
by: roryaPosted on 2007-09-25 at 04:22:16ID: 19954742
Is the other workbook open?