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
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