Move to cell below pasted values

[jeroen1994]

Hi,

• I am using a Macro-recorder to help copy names from our software system to an Excel sheet.
  
  
• The number of rows is often not equal, sometimes 1 name/ 1 row, sometimes 6 names/ 6 rows.
  
  
• I would like to continually keep pasting names under eachother without empty rows, to do this I want to move to the cell below the pasted values. Anybody that could help me out?

Currently I have my macro move down 6 rows, after pasting the data, but that often leads me with some empty rows that I have to remove later.

 

[offthelip]

Welcome to the forum, if you post the code for the macro that you are currently using we may be able to modify it to select the next blank row. To post code click the VBA icon and then paste your code. This will format it to look like code on our forum