Previous Topic Next Topic

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

Answer 1 / 1
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)
0
Dbibb
Mar 4, 2010 at 01:23 AM
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

Similar discussions

Macro copy and paste in next blank cell
fhernnet -
pratheepM7 -

10 responses
Select and copy only nonblank cells
shootingfish -
Ambucias -

5 responses
Copy data onto sheet only if cell has text
danipants -
checjb -

17 responses
Excel - A macro to create new workbook and copy data
Shridharb2002 -
TrowaD -

29 responses
Excel VBA copy and paste loop with logic condition
Yogibearv -
Yogibearv -

6 responses
Macro to Create New Workbook and Copy Data at Each Change of X
greatdanejes -
vcoolio -

1 response