|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#3
07-05-2018, 06:06 AM
|
|||
|
|||
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| extract time from a cell and move it to front of cell before text | ewso | Excel | 20 | 03-19-2017 11:34 AM |
| Move the data at bottom cell to right side of the cell | kcyag91 | Excel | 1 | 01-28-2016 12:28 AM |
| Data validation,force cell to be filed with number if respective cell is not empty | nicholes | Excel Programming | 0 | 08-01-2015 09:08 AM |
 If id cell range is empty then should not allow to fill any other cell
|
ubns | Excel Programming | 2 | 04-12-2015 06:31 AM |
| Move data from 1 cell to another cell | Catalin.B | Excel | 1 | 06-25-2011 12:51 PM |
Windows 7 64bit 
Office 2016
Threaded Mode