| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy data in a macro.
I have recorded a macro to copy formula from one cell to a range of cells
using end and down arrow key in the macro to pick up the last record based on the column to the left, this has dropped into the macro the last cell reference. How can I include in the macro to copy to the last record line (which could be variable) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy data in a macro.
Hi,
Copies the last used cell in column A. Sub versive() Cells(Rows.Count, 1).End(xlUp)(1).Select Selection.Copy End Sub Rows.Count, 1) change 1 to to for col B etc Mike "jfaz" wrote: I have recorded a macro to copy formula from one cell to a range of cells using end and down arrow key in the macro to pick up the last record based on the column to the left, this has dropped into the macro the last cell reference. How can I include in the macro to copy to the last record line (which could be variable) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help. Copy data from 1 workbook to another on next available | Excel Discussion (Misc queries) | |||
| Macro to copy data from One sheet to another | Excel Discussion (Misc queries) | |||
| Macro: Insert, copy and past data from sheet | Excel Discussion (Misc queries) | |||
| Macro to copy data into another workbook | Excel Discussion (Misc queries) | |||
| Create Macro to Copy Data from one spreadsheet to another | Excel Discussion (Misc queries) | |||
Linear Mode
