| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fill Down to Stop at Last Row
How can I make this to stop at the last used row? It goes to the row 65536
Sub FillDownByColumn() Do Until y = Range("A1").CurrentRegion.Rows.Count - 1 Selection.End(xlDown).Activate Range(Selection, Selection.End(xlDown).Offset(-1, 0)).Select Selection.FillDown y = Selection.Row Loop End Sub Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in Save As,how to stop auto fill in whatever the mouse hovers on? | Setting up and Configuration of Excel | |||
| Stop Overwriting (Fill, Copy, etc) Data Validation | Excel Discussion (Misc queries) | |||
| How do I stop Excel from progressing a formula in fill down or rig | Excel Worksheet Functions | |||
| stop auto fill from thinking for itself!!!!!!! | New Users to Excel | |||
| How do I stop other circles in other boxes to stop selecting? | Excel Worksheet Functions | |||
Threaded Mode
