Macro that goes to next blank cell
Solved/Closed
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
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
Related:
- Macro that goes to next blank cell
- Different dates of end to end encryption message on blank chat ✓ - WhatsApp Forum
- Based on the cell values in cells b77 ✓ - Excel Forum
- Different dates of "end to end encryption message" on blank chat? - Google Chrome Forum
- Using web browser page loads but screen blank ✓ - Network Forum
- Run macro when cell value changes by formula ✓ - Excel Forum
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
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)
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)
Mar 4, 2010 at 01:23 AM
Mar 4, 2010 at 05:46 AM