Excel macro Commands

Can you not just simply use the "Record Macro" function?

Using the record macro function is how I created the distribution macro in the first place. But trying to place the cursor refers to a specific cell, not just the next unoccupied cell. I think I need a logic command.

How about trying something like:

Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select

First command should take till the end of the data and next one offsets by one row.

I like that answer, it is better than what I was going to suggest which was keep a counter variable running in the spreadsheet that gets updated by the number of new datapoints each time it runs.

I'll try this method and let you know how it works. Seems like a lot of code just to move the cursor. It's going to make the macro very long. I've already chopped it into two pieces just to make it run.

It can be shortened as follows:

Cells(ActiveCell.Row + 1, ActiveCell.Column).Activate

I only used variables only to minimize the chance of error. I'm not in any way a master programmer, but I've been around it enough to accomplish what I need.

I've found that sometimes when you call the value of an object directly, if gives an error. But when it is stored in another variable first, everything is fine. Something to do with the Object-Oriented Programming, I think.

So, if you want, remove the 2 Dim statements & replace the 3 prior lines of code with the one listed above.

How big is this macro? Sounds pretty substantial for 5 lines of code to make it "very long"...

You might be able to simplify it with code not generated by excel. Such as a Do...Loop Event

Thank you very much for your interest and your input. The other suggestion worked as hoped so I'm using it now. I think this exchange has piqued my interest enough to make me want to get a book on Visual Basic and try to get more competent. Thanks again for your input.

Thanks, I'll try the second line of code because the cursor already resides in the last occupied cell. I'll try your sugestion first because it's a lot shorter and simpler.

Inserted the second line of code in the macro after every instance of having pasted the value in the first vacant cell, but before saving and closing the worksheet -- works flawlessly! Thanks a lot. Will save me close to an hour of computer time every night.