Next row

Closed
carmen - Sep 24, 2010 at 01:22 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 25, 2010 at 07:11 AM
Hello,
I created a new excel, looking to move the entered data to another tab and move to the next row once the macro runs. Which is the command to place move to the next empty row? Thanks for all your help

Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 25, 2010 at 07:11 AM
if it is in the same sheet the code

dim c as range
set c=<some cell? e.g. ramge("A1")

c.offset(1,0)will be A2

if in a different sheet slightly different

dim  c as range,j as range, k as range 
set c =range("A1")
j=c.row
k=c.column
c.copy worksheets("sheet2").cells(j+1,k)


use this knowledge to get a solution to your problem
0