immediate window

I am trying to display a large number of values to the Immediate Window while testing my VBA code. Unfortunately, I can only get ~100 values to be visible. Is there any way I can get all my values to display? Thanks!

Hi All. Does one here know if it is possible to count the number of cells in a range that have a specific color? I have tried this and it does not work: ?Application.worksheetfunction.countif(Range("A1:A10);interior.color = rgbred))

I narrowed it don't to this: Function test(oRange) 'called by A1: =test(B1) test2 oRange 'this works Stop 'BUG: "test2 oRange" in the Immediate window while here in debugmode gives: "Run-time error '51': Internal error" End Function Function test2(ParamArray...

Hi all, I have the following code Range(Output).Offset(0,1).Value = "to" Range(Output).Offset(0,1).HorizontalOffset = xlCenter. There is a bunch of code after this. Everything works fine until it gets to the HorizontalOffset statement. Then the sub stops running with no error. The text does...

Why do I get an "Internal error" '51' when trying to pass a range-object-parameter to a new sub ParamArray-parameter from the immediate window ? Sub sStart() sTest Selection End Sub Sub sTest(oPar) Set oTest = oPar Stop ' here I type in the immediate window: '...

Hello fellow Excel friends, A co-worker of mine was helping me out with a piece of code and used the immediate window to quickly print out properties and evaluations of expressions without needing to use a msgbox. I am trying to figure out how to do just that. From what I know, all you are...

I have tracked down an overflow Error 6 to the following line: dMax = Int(s * DPoints / SPoints) Where all variables are defined as Integers. The error goes away when I define s as Long, but I don't understand why this should be required since none of the individual variables ever exceed the...

I'm having a problem creating a VBA ADO to call a select statement from a table and display it in the immediate window. (I really have no idea where to start either) http://www.blackbootmedia.com/School/FinalProject.accdb What I need to do is "Create a VBA function to produce a report in the...

Hi, Whenever I run the code below in the module the msgbox returns a value, i.e 9 (signifying 9th row). Sub test() x = ActiveCell.Row MsgBox x End Sub But whenever I use the immediate window (print x) or the watch window (x) nothing happens . In other words...