| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a cell from a previous worksheet using a macro
Sub Macro4()
' ' Macro4 Macro ' Macro recorded 31/01/2006 by McNaughton ' ' Keyboard Shortcut: Ctrl+n ' Cells.Select Selection.Copy ActiveSheet.Next.Select ActiveSheet.Paste ActiveCell.Offset(32, 0).Range("A1:D54").Select Application.CutCopyMode = False Selection.ClearContents ActiveCell.Offset(-31, 6).Range("A1:A85").Select Selection.ClearContents ActiveCell.Offset(0, -2).Range("A1").Select Selection.ClearContents ActiveCell.FormulaR1C1 = ActiveSheet.Previous.Range("F86") End Sub Hi, what is this macro suposed to do?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to insert row and copy previous row + excel | Excel Discussion (Misc queries) | |||
| Copy worksheet to new doc w/formulas not referencing previous doc | Excel Discussion (Misc queries) | |||
| Need A Macro To Copy Previous Tab to New Tab | Excel Discussion (Misc queries) | |||
| Macro to copy previous row and insert two blank rows | Excel Discussion (Misc queries) | |||
| Copy Formatting of previous worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
