All Questions
Tagged with excel compiler-errors
186
questions
0
votes
1
answer
123
views
Getting error for COM excel when trying to build project in Visual Studio
Using Bitbucket as remote repo.
Created a Https token in bitbucket
When trying to clone using Visual Studio it asked for username and password. I provided with my username and for password gave the ...
2
votes
1
answer
109
views
Excel VBA: data member not found
This question is related to the VBA compile error "Method or Data Member not found". I have looked for the answer to my question in many of similar questions with this title but I did not ...
0
votes
1
answer
66
views
How to avoid Compile Error: Object Required in this VBA code?
I am trying to create a running counter using x every time the string "YES" appears in column F. The code I'm trying to fix is searching for the string using the .Find and .FindNext ...
0
votes
1
answer
102
views
In VBA is it possible to get the value of a button on a worksheet which is stored as a variable?
In VBA is there a way to refer to a button on a worksheet that's held as a variable? Unless I refer to the sheet directly it seems to throw a compile error for "Method or data member not found&...
1
vote
0
answers
37
views
Java Mail Merge Application Compilation Error: "Illegal start of expression"
I'm trying to run a small Java application that performs a mail-merge functionality on Microsoft Word documents using data from CSV/Microsoft Excel files. The goal is to replace markers in the Word ...
0
votes
1
answer
69
views
How to resolve error 91 when running code to populate list box selection in userform into excel cell?
I have a form that contains a list box and I'm trying to write the code to populate the selected items (multiple selection) from the list box into the excel sheet. I got error 91 (object variable or ...
0
votes
2
answers
111
views
VBA - Is the IsDate(expression) function broken or am I being an idiot?
I might be completely missing something blatantly obvious or just generally being stupid but the IsDate() function in VBA won't return anything other than "Compile error - Wrong number of ...
0
votes
0
answers
69
views
How do I correctly use a dynamic array in VBA to avoid the Expected Sub, Function or Property error?
Having trouble getting code to compile due to an array name throwing the Expected Sub, Function or Property error.
Function is to take two input ranges, one of strings and one of times.
Strings are ...
0
votes
1
answer
86
views
Excel VBA Compile Error Cant Find Library or Project
I am getting this error when I try and run an excel Userform on any other computer than the computer that developed the form.
Compile Error:
Cant Find Library or Project
Here is the code giving the ...
1
vote
1
answer
205
views
How to fix "compile error: End If without block If."
I got this code, and for whatever reason, the 'End If' can't find the block If statement. I've tried a couple solutions but I can't get it to work. Any advice would be greatly appreciated.
I'm unsure ...
0
votes
1
answer
76
views
VBA running a function by name of string
Is it possible to run a function bases on a variable from a cell in excel?
Option Explicit
Dim retval As Integer
Sub main()
Dim sht As Worksheet
Set sht = ActiveSheet
Dim ...
0
votes
1
answer
62
views
"Compile Error: End With without With" although there is a With block start
I'm having an issue with this block of code. Ultimately, this module should take the number of calls within a neighbourhood and compare it to the city average.
Here is the block:
Option Explicit
Sub ...
0
votes
1
answer
68
views
End With without With and End If without If compile error
I have a code that contains nested if statements, I am getting either an "End With without With" or an "End If without If" errors. I need help what I should change in my code. Here ...
0
votes
0
answers
373
views
VBA Excel Compile error: Expected: end of statement
I'm trying to add a formula in cell AE2 to my worksheet with the help of VBA Excel.
However when I paste the formula in VBA and hit enter on the line I get the following error:
Compile error: ...
0
votes
0
answers
45
views
Same structure,different files but still Compile Error?
Hi can someone actually find the wrong syntax here. As i run the VB code, it kept saying compiling error and highlighting the syntax Controls. Tried the same code before at different files and runs ...