Question

0

233

Vistas

I need to copy value (not formula) from "Regular Tournament" to "Score Input-Flights" without using Select and Paste Value. Is there a simple formula?

I'm looking for a simple way to copy values only (omitting formulas) from one sheet to another without using .Select and PasteSpecial.Values. I have hundreds of sections of code like this one that need modification. I've searched the web but can't find anything that works.

Sheets("Regular Tournament").Select
Range("B22:B221").Select
Selection.Copy
Sheets("Score Input-Flights").Select
Range("D13").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
            False, Transpose:=False
Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:= _
            False, Transpose:=False

about 4 years ago · Santiago Trujillo

1 Respuestas

Responde la pregunta

0

Responde la pregunta

Encuentra empleos remotos

Answer 1 · 2022-06-24T22:49:57.290Z

Let me give you a simple idea (in VBA):

Destination_Range.Value = Source_Range.Value

In your case:

Sheets("Score Input-Flights").Range("D13:D212").Value = Sheets("Regular Tournament").Range("B22:B221").Value

In regular Excel it's even simpler: just use this formula:

='Regular Tournament'!A1

0

233

I need to copy value (not formula) from "Regular Tournament" to "Score Input-Flights" without using Select and Paste Value. Is there a simple formula?

1 Respuestas

0

Encuentra empleos remotos

Andres GPT