Home » Forums » Open Source Learning Center » Question and Answer

Copy from immediate window to spreadsheet

Submitted by iamspaz on 24 August, 2012 - 01:54

Help!

‹ Numbers convert into words Using functions to search cells in one sheet and paste in another. ›
»
Nick's picture

getting data from immediate window

Submitted by Nick on 24 August, 2012 - 12:17.

... u need to do this in the VBA

add a sheet called "Log"
everywhere you find debug.print "xxx", add a line:

sheets("Log").cells(rows.count,1).end(xlup).offset(1) = "XXX"

»

getting data from immediate window

Submitted by amoolyas@gmail.com on 4 October, 2012 - 03:09.

Hello Nick,

after a through search, I found your suggestion was working.

Can you please give a full sample small script.
Much appreciated mate.

Thanks,
Amool

»