| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the next blank cell
Hi,
Can someone please explain why this throws up an error "Select method of range class failed" (on the .Select line) Sheets("ChartsM").Cells(5000, "N").End(xlUp).Select Set rCurrentCell = ActiveCell I have repace it with: Do Set rCurrentCell = rCurrentCell.Offset(1, 0) Loop Until rCurrentCell.Value = "" which works, but I'd like to undersand what I'm doing wrong. TIA Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Next Blank Cell in Blank Row | Excel Worksheet Functions | |||
| Finding next non-blank cell | Excel Discussion (Misc queries) | |||
| Finding next blank cell | Excel Programming | |||
| Finding the Blank Cell | Excel Programming | |||
| Finding first non-blank cell | Excel Programming | |||
Threaded Mode
