If loops including Cell numbers
Posted by Mike W on September 27, 2001 5:35 AM
I'm trying to set up a spreadsheet so that when you press a button on it, it will prune certain data and copy that data to another file.
This part I have managed ok thanks to other posts in this forum.
However, what I want to do is make it so that every time the button is pressed, it is ADDED to the data in the second file, but doesn't overwrite it.
To me it seems the simplest way of doing it is to check the target cell and see if it is blank. If it's blank it'll paste the data, if not, it'll check the next cell down.
That's where the problem begins. How do I integrate cell numbers into an IF loop in VB?
Essentially what I want is:
If Ax="(blank)" then paste
then repeat the loop.
The trouble I'm having is integrating the Cell numbers into this.