| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to check for next empty cell in list
BlankI'm fairly new to vba....if someone could assist please.......
What is the best code for checking for the next empty cell in a list? A 1 a 2 b 3 c 4 d 5 <-- checking for this empty cell 6 7 Thanks for any help........ Don |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to check for next empty cell in list
BlankDon,
This should do it Cells(Rows.Count,"A").End(xlUp).Offset(1,0).Select -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "DonW" wrote in message ... I'm fairly new to vba....if someone could assist please....... What is the best code for checking for the next empty cell in a list? A 1 a 2 b 3 c 4 d 5 <-- checking for this empty cell 6 7 Thanks for any help........ Don |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to check for next empty cell in list
BlankCells(1, 1).End(xlDown).Offset(1, 0).Select
"DonW" wrote in message ... I'm fairly new to vba....if someone could assist please....... What is the best code for checking for the next empty cell in a list? A 1 a 2 b 3 c 4 d 5 <-- checking for this empty cell 6 7 Thanks for any help........ Don |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to check for next empty cell in list
BlankThanks Bob
"Bob Phillips" wrote in message ... Don, This should do it Cells(Rows.Count,"A").End(xlUp).Offset(1,0).Select -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "DonW" wrote in message ... I'm fairly new to vba....if someone could assist please....... What is the best code for checking for the next empty cell in a list? A 1 a 2 b 3 c 4 d 5 <-- checking for this empty cell 6 7 Thanks for any help........ Don |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation List that will not allow cell to be empty | Excel Worksheet Functions | |||
| list from empty data cell source | Excel Worksheet Functions | |||
| compile list in 1st empty cell | Excel Discussion (Misc queries) | |||
| How do I check for an empty cell in a formula? | Excel Discussion (Misc queries) | |||
| vba - check if cell is empty | Excel Programming | |||
Linear Mode
