Line of code causing a beeping sound

E

ExcelMonkey

I have a line of code that I am using in VB. Not the line of code is
actually VBA code being used in VB (via Visual Studio 2008 Express). It is
giving me a beeping noise. Its the line " .ShowDependents()". Why would this
be happening?

With rng
If .DirectDependents Is Nothing Then
.ShowDependents()
End with

Thanks

EM
 
J

JLGWhiz

If DirectDependents Is Nothing, then you are probably hearing beep when the
error message pops up to tell you that there are no dependents for that cell.
Maybe you meant to write If Not DirectDependents Is Nothing Then....
 
E

ExcelMonkey

Thanks. Will look into it and write back.

EM

JLGWhiz said:
If DirectDependents Is Nothing, then you are probably hearing beep when the
error message pops up to tell you that there are no dependents for that cell.
Maybe you meant to write If Not DirectDependents Is Nothing Then....
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a DLL for Excel 3
Cant "picture" Format from Clipboard to .bmp file type 6
How to Call (utilize) a Sub() in a Class DLL? 9
Sound alert 3
Check for duplicate values 5
Problem with line of code / syntax 4
[VBA] Get the content of each value of a line 8
VB.NET with Excel VBA 3

Top