| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy active row and repaste values
keep getting runtime error....
want to copy active row and repaste values only. Sub Macro3() ActiveCell.Offset(Rowcount).EntireRow.Copy Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy active row and repaste values
Sub Macro3()
ActiveCell.EntireRow.Copy Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False End Sub "J.W. Aldridge" wrote in message ... keep getting runtime error.... want to copy active row and repaste values only. Sub Macro3() ActiveCell.Offset(Rowcount).EntireRow.Copy Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False End Sub |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy active row and repaste values
THANX ALL!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find matching values, copy/paste values as well as values in ColA | Excel Programming | |||
| Copy active sheet to new - do no copy buttons | Excel Programming | |||
| Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
| Update Values as soon as a Worksheet becomes active? | Excel Programming | |||
| HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) | |||
Linear Mode
