Macro that goes to next blank cell

Solved/Closed
dbibb - Mar 3, 2010 at 03:35 PM
 Fruits and Veggies - Apr 7, 2010 at 10:39 PM
Hello,
im using excel 2007 and I have a cell which I input a number inn and then a macro that runs copying the contents to another column which then adds the contents up. but when the macro is run again I want it to copy the contents into the next blank cell within that column every time it is re run.

here's the macro

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 3, 2010 at 04:48 PM
I dont know how you are getting to that column/cell

but this gives you last row that has been used


lastrow=cells(65536, 1).end(xlup).row

1 refers to column A, it finds the last used column in A (unless nothing is in col A in which case 1 is returned)
That didn't work. I'm getting to column j By clickin on j2 with mouse as the macro was recorded but after j2 has been used I want the macro then to copy data to the cell below which is blank. And then hAve the macro do thAt agin So it is as if it is plus 1 after each time it is run
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > Dbibb
Mar 4, 2010 at 05:46 AM
post the relevant portion of the code
0