ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Debug to Output (https://www.excelbanter.com/excel-programming/395776-debug-output.html)

Paul Black

Debug to Output
 
Hi everyone,

How can I get ...

Debug.Print "For 1 -"; TOP; "there are"; tly; "different lists of"; x;
"numbers."

.... to pint in a sheet named "R1" and in Cells B3:whatever please.

Thanks in Advance.
All the Best.
Paul


Mike H

Debug to Output
 
Hi,

I assume Top, tly etc are variable.

Range("B3").Value = "For 1 -" & Top & "there are" & tly & "different lists
of" & x & "numbers."

try this.

Mike

"Paul Black" wrote:

Hi everyone,

How can I get ...

Debug.Print "For 1 -"; TOP; "there are"; tly; "different lists of"; x;
"numbers."

.... to pint in a sheet named "R1" and in Cells B3:whatever please.

Thanks in Advance.
All the Best.
Paul




All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com