• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

First empty cell Column

S P P

Member
Last empty cell column(2)
ActiveSheet.ListObjects(1).Range.Columns(2).Find("", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Activate

How would it be
First empty cell Column(2)
 
Maybe just:
Code:
ActiveSheet.ListObjects(1).Range.Columns(2).Find("", SearchOrder:=xlByRows, SearchDirection:=xlNext).Activate
 
The only way I know with a Table without Headers is to leave the Headers visible and use the white color for the interior and font on those cells to 'hide' them. This will let you use the above code and if the column is empty it will activate the first cell instead of the second.
 
rollis13

I'm going to use it anyway, just don't select the first cell, but in the second it already works.

Thanks
 
Back
Top