Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help copying certain cells from current row
I want to be able to select contents of cells in columns B thru E in the
current row (the row where the cursor is in) and then paste that info into cells row 2 coulmn F thru I. Then place the cursor back in the next row after the original row. Sounds easy, but it's not for me. Any help would be appreciated. Jonco |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help copying certain cells from current row
Assuming you want to paste the data in the same row as the current row.
Sub CurrentRow() ' 'I want to be able to select contents of cells in columns B thru E in the 'current row (the row where the cursor is in) and then paste that info 'into cells row 2 coulmn F thru I. Then place the cursor back in the 'next row after the original row. Dim aWS As Worksheet Dim myRow As Long Dim myRange As Range Set aWS = ActiveSheet myRow = Selection.Row Set myRange = aWS.Cells(myRow, 2).Resize(1, 4) myRange.Offset(0, 4).Value = myRange.Value aWS.Cells(myRange.Row + 1, myRange.Column).Select End Sub -- HTH, Barb Reinhardt "Jonco" wrote: I want to be able to select contents of cells in columns B thru E in the current row (the row where the cursor is in) and then paste that info into cells row 2 coulmn F thru I. Then place the cursor back in the next row after the original row. Sounds easy, but it's not for me. Any help would be appreciated. Jonco |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help copying certain cells from current row
hi
another way. Sub copyit() Dim r As Range Set r = ActiveCell Range(r, r.Offset(0, 4)).Copy Destination:=Range("F2") r.Offset(1, 0).Select End Sub regards FSt1 "Jonco" wrote: I want to be able to select contents of cells in columns B thru E in the current row (the row where the cursor is in) and then paste that info into cells row 2 coulmn F thru I. Then place the cursor back in the next row after the original row. Sounds easy, but it's not for me. Any help would be appreciated. Jonco |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter - Copying to location other than current sheet? | Excel Discussion (Misc queries) | |||
Adding to current cells | Excel Worksheet Functions | |||
Ms Excel, Copying Cell to current sheet using 'Right Click' | Excel Discussion (Misc queries) | |||
filter gives no output, no copying necessary of current.region | Excel Programming | |||
copy current cells to the right | Excel Programming |