LinkBack URL
About LinkBacks
I need a macro which 'sends me' to the last cell, with any content, in a column.
In this example I want the macro to send me to D22, but the number of rows, which
are filled out, varies and could be thousends of rows.
Could someone help me?
I need a macro which 'sends me' to the last cell, with any content, in a column.
In this example I want the macro to send me to D22, but the number of rows, which
are filled out, varies and could be thousends of rows.
Could someone help me?
Last edited by Saturn; 07-09-2013 at 11:37 AM.
Hi, Saturn,
if the column is thoroughly filled:
If there are gaps in between the code above will you send to the last cell of the block. The last cell of cteh Column could be reached by
Please Login or Register to view this content.
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Here:
Please Login or Register to view this content.
Never use Merged Cells in Excel
Hi, zbor,
maybe you better change the constant number of rows to work with what´s in the sheet like
since there are just a couple of more rows available from 2007 on (only from 2^16 to 2^20Please Login or Register to view this content.).
Ciao,
Holger
PS: double post of yours due to Forum Backup/Maintenance.
Hi HaHoBe and zbor
None of these codes works. The one from HaHoBe sends me to the very last row in the sheet.
I would like to have the code for the last row/cell which is filled out in a particular column.
Any other suggestions ?
FWIW:
Please Login or Register to view this content.
Try...
Please Login or Register to view this content.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks