Finding the last column in a row using VBA


Posted by Skip Bisconer on December 12, 2000 5:24 PM

I know how to find the last row in a column plus 1 to get the next available empty row is there a way to do the same for the last column in a row?

Posted by George on December 13, 2000 2:01 PM

I am looking for something similar. Looking to sort lists of accounts receivable to move them to other pages in a workbook.

http://www.zdnet.com/zdhelp/stories/main/0,5594,2567395,00.html

This did not exactly help me with a direct answer but you might find some use to the code that is included in this article.
Good Luck, my search continues.



Posted by Celia on December 13, 2000 3:04 PM


Range("IV1").End(xlToLeft).Offset(0,1).Select