| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros-autofill down to one row above next data field
I tried using the relative reference to automatically (shift-end-down arrow
then up arrow one row) to autofill. The number of rows will vary each time. The macro doesn't record properly. What is the best way to handle this? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros-autofill down to one row above next data field
Sub Selectdown()
Range(ActiveCell, ActiveCell.End(xlDown).Offset(-1, 0)).FillDown End Sub Gord Dibben MS Excel MVP On Mon, 30 Jul 2007 12:08:03 -0700, Terry wrote: I tried using the relative reference to automatically (shift-end-down arrow then up arrow one row) to autofill. The number of rows will vary each time. The macro doesn't record properly. What is the best way to handle this? Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros-autofill down to one row above next data field
That does it. Thank you.
Terry "Gord Dibben" wrote: Sub Selectdown() Range(ActiveCell, ActiveCell.End(xlDown).Offset(-1, 0)).FillDown End Sub Gord Dibben MS Excel MVP On Mon, 30 Jul 2007 12:08:03 -0700, Terry wrote: I tried using the relative reference to automatically (shift-end-down arrow then up arrow one row) to autofill. The number of rows will vary each time. The macro doesn't record properly. What is the best way to handle this? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros or the Fastest way to Autofill Rows | Excel Discussion (Misc queries) | |||
| macros for autofill | Excel Worksheet Functions | |||
| Click in one field and data presented in another field | Excel Discussion (Misc queries) | |||
| data in primay field changed however subsequent field does not upd | Excel Discussion (Misc queries) | |||
| Recording macros with autofill | Excel Discussion (Misc queries) | |||
Linear Mode
