How to use .Value instead of .Select

Asked Jul 22 '22 at 15:14

Active Jul 22 '22 at 15:17

Viewed 24 times

does anyone have any insight on how to change this so I can just use value instead of select? I'm not sure how to incorporate it with the dynamic range, and when I did, it just populated in column A. Here's what I have:

    Dim lastrow As Integer
    lastrow = Range("A" & Rows.Count).End(xlUp).Row

    Dim I As Integer
    For I = 2 To 325    

        Sheets("Cashflows").Range("A3").Value = Sheets("Input").Range("A" & I)

        Sheets("Cashflows").Range("A3:Z3").Select
        Selection.Copy

        Sheets("Output").Range("A" & I).PasteSpecial Paste:=xlPasteValues

    Next I

End Sub

edited Jul 22 '22 at 15:16

JNevill

46,980
4
38
63

asked Jul 22 '22 at 15:14

amcook1989

Just do `Sheets("Cashflows").Range("A3:Z3").Copy` – JNevill Jul 22 '22 at 15:16
1

`Sheets("Output").Range("A" & I & ":Z" & I).Value = Sheets("Cashflows").Range("A3:Z3").Value` – Scott Craner Jul 22 '22 at 15:16

How to use .Value instead of .Select

0 Answers0