Macro that goes to next blank cell
Solved/Closed
Related:
- Macro that goes to next blank cell
- Different dates of end to end encryption message on blank chat ✓ - WhatsApp Forum
- An example of a cell is a blank cell ✓ - Programming Forum
- Spell number in excel without macro - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
- Different dates of "end to end encryption message" on blank chat? - Google Chrome 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