VBA code to set Range row number based on cell value

[rjheibel]

I would like to set the row number in my paste formulas Range based on the value in Cell A3 on a specified worksheet. Specifically in the code below, I would like the value of P5000 to be based on the value in cell A3. Any help would be greatly appreciated.

Sheets("Expected Finish Dates").Select
Range("B4034:P4034").Select
Application.CutCopyMode = False
Selection.Copy
Range("B4035:P5000").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

 

[Fluff]

Will A3 hold the number of rows the formulae should be copied to, or the last row number?

 

[rjheibel]

I ended up using the following code, which worked....

Sheets("Expected Finish Dates").Select
    Dim LastRow
    LastRow = Range("A3").Value
 
    Range("B4034:P4034").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("B4035:P" & LastRow).Select
    Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False

 

[Fluff]

Glad you sorted it & thanks for the feedback.