|First, you don't need the + sign in an Excel formula.|
Second, you could do it without a macro:
In a "spare" column e.g. G, try this:
Enter 502 in G1
Enter =G1+58 in G2
Drag it down as far as you need.
In the cell where you want your first formula enter:
Make sure you include the single quotes around the Sheet name.
Drag this down as far as you need.
Finally, if you want a macro, try this:
- Your first formula goes in A1
- You need 10 formulas, from C502 to C1024
For nxt58 = 502 To 1024 Step 58
myRw = myRw + 1
Range("A" & myRw).Formula = _
"='Prospect Details'!C" & nxt58
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.