Hi,
I have created a simple example to demonstrate my needs.
Is it possible to write 16 numeric values (from my 16x for
loop) “press and temp”, to my new report (from my defined template).
My two main issues are:
Each time it iterates through the loop, it floods the
defined ranges with the same press and temp values. As I have defined my range
as being 16 deep, i would like each iteration of the loop to incrementally populate
the next available cell only.
Considering the above i would also only like one excel book
to be opened then populated incrementally. What is happening just now is, for
each iteration of the loop it creates a new book. Which, to be honest is what I
expected to happen, but not the behaviour im looking for.
Any ideas?
Many thanks
