Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding empty rows
How can I write a sub-routine that will look for an empty row. I.E. Rows
B2 to B7 have already numbers or texts in these cells. It will check if the cells are empty or not. If a cell is used it skip down to next cell and until it finds an empty cell. In this case the empty cell will be B8. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding empty rows
Try this:
Range("B" & Range("B" & Rows.Count).End(xlUp).Row + 1).Select Regards, Stefi €˛ogopogo5€¯ ezt Ć*rta: How can I write a sub-routine that will look for an empty row. I.E. Rows B2 to B7 have already numbers or texts in these cells. It will check if the cells are empty or not. If a cell is used it skip down to next cell and until it finds an empty cell. In this case the empty cell will be B8. *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding empty rows
Hi Stefi
Thank you for the help. I copied & paste and tested, it works. Once again,thank you. *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding empty rows
You are welcome! Thanks for the feedback!
Stefi €˛ogopogo5€¯ ezt Ć*rta: Hi Stefi Thank you for the help. I copied & paste and tested, it works. Once again,thank you. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding empty rows | Excel Programming | |||
Finding 5 consecutive empty rows | Excel Programming | |||
finding empty rows and deleting | Excel Programming | |||
Finding Empty Rows | Excel Programming | |||
Finding Empty Rows | Excel Programming |