Have you tried this idea
Sub changesourse()
Columns(2).Replace "sheet2", "sheet3"
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RedFive" wrote in message
...
I have a spreadsheet that I am using as a template. My problem is that I
want to be able to change the source that the formulas pull the data from.
I
used the Macro recorder, but now I have to enter the source path for each
column, about 8 times. There has to be a better way, does anybody know?
I
thoght a Do Until loop might work, but not sure how to write it into the
recorded code. Thanks
--
RedFive