who can i make this line of code just values?

[Sonythenovice]

Hi everyone,

i have a very large macro and in it one line of code copys and pastes but i want the paste to be just values

heres the code

Range(rngDataStart.Offset(1, c), rngDataStart.Offset(59, c)).Copy rngTarget.Offset(4, 0)

 

[Rick Rothstein]

Hi everyone,

i have a very large macro and in it one line of code copys and pastes but i want the paste to be just values

heres the code

Range(rngDataStart.Offset(1, c), rngDataStart.Offset(59, c)).Copy rngTarget.Offset(4, 0)

If your rngTarget range already references 59 rows down, then this should work...

[table="width: 500"]
[tr]
	[td]rngTarget.Offset(4, 0).Value = Range(rngDataStart.Offset(1, c), rngDataStart.Offset(59, c)).Value[/td]
[/tr]
[/table]

otherwise if rngTarget is a single cell reference, then this should work instead...

[table="width: 500"]
[tr]
	[td]rngTarget.Offset(4, 0).Resize(59).Value = Range(rngDataStart.Offset(1, c), rngDataStart.Offset(59, c)).Value[/td]
[/tr]
[/table]

 

[ranman256]

Range(rngDataStart.Offset(1, c), rngDataStart.Offset(59, c)).Copy
rngTarget.Offset(4, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False

 

[MARK858]

@ranman256, why the Select and Selection?