| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last cell with data in...
Hi there,
Im trying to apply borders to a series of cells in column P, that starts in P2, and ends where the last bit of data is in that column. However there may well be blanks in between... Ideas? Thanks!!! D *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Last cell with data in...
Set LastCell = Cells(Rows.Count,"P").End(xlUp)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Darin Kramer" wrote in message ... Hi there, Im trying to apply borders to a series of cells in column P, that starts in P2, and ends where the last bit of data is in that column. However there may well be blanks in between... Ideas? Thanks!!! D *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Last cell with data in...
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i find specific data in a cell and its colocated cell data | Excel Worksheet Functions | |||
| converting numerical data in one cell to word data in another cell | Excel Worksheet Functions | |||
| how to find number in a cell , a cell contains character data ornumeric data | Excel Worksheet Functions | |||
| Find MAX data in sheet (Cell) - Any cell that exceeds X amount of data | Excel Discussion (Misc queries) | |||
| data validation to restrict input in cell based on value of cell above that cell | Excel Programming | |||
Hybrid Mode
