Thread: Find last non empty cell (moving horizontally), then move one cell to the right
View Single Post
 
Old 07-05-2018, 06:06 AM
klutch klutch is offline Windows 7 64bit Office 2016
Advanced Beginner
  
Join Date: Jun 2018
Posts: 31
klutch is on a distinguished road
Default
Could you be a little more informative? I am very new to vba!
There are 7 columns and 11 rows that I have in the table. the cell I want to select will be in a row partially filled with data, meaning columns 1,2 of that row will have text in them. I want to select either that last cell with text in it (in column 2) OR select the first blank cell of that row. How would i use the .cells property of the table range to do this?
Reply With Quote