debug.print

I have 2 excel sheets one is a copy of the spreadsheet that google forms gives me. The other is one I want to update “Tracking 12 Mo MovAvg”. I would think the wild cards would qualify the “like”, but that is not the case. Any thoughts on what I’m doing wrong. Indents are not showing up in the...

https://www.screencast.com/t/xO9c1xi7M9D Is there any way to stop this from popping up while I am running my code? The Immediate window is empty and there are no lines of code referring to Debug.Print. Using Excel 365 and Windows 10 64 bit. Any help would be greatly appreciated.

I have one module with all the public constants stored and cleared. When I am running a module with refers to this module, I can see neither the module nor its values. For me it seems like the VB-Editor is only able to show one module in "Locals" at the same time. Until now I have used the...

Sorry if this posted already, I was having issues with it! Hi There. I am having an issue with printing an Array to the immediate window using Debug.Print. I have a column heading containing HP1 and HP2 and another column heading containing HP3 and HP4. The ideal case is HP1=HP3 and...

Hi There. I am having an issue with printing an Array to the immediate window using Debug.Print. I have a column heading containing HP1 and HP2 and another column heading containing HP3 and HP4. The ideal case is HP1=HP3 and HP2=HP4. I created a new column called HP5 and HP6 which should contain...

I have been working with a simple macro that I have recreated several times. I normally put it into Thisworkbook or into its own Module for the file I'm working with. Each time I needed to check against a new manufacturer I exported my required information and retyped the macro. For Each r...

I thought I rather not ask but what does this line mean in "Debug.Print wb.Name" ???:biggrin: For Each wb In Workbooks MsgBox wb.Name Debug.Print wb.Name Next wb aLeng