Question

0

232

Views

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 answers

Answer question

0

Answer question

Find remote jobs

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

232

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 answers

0

Find remote jobs

Andres GPT