I currently am working on a spreadsheet that I am trying to automate
and extremely repetitive task on. Right now I have the following
formula in each cell:
=DCOUNTA(Query!$A$1:$C$50319,Query!$A$1,Calculatio ns!$DM$3:$DP$4). All
I am trying to do is to be able to change the 3 and the 4 to another
number using a macro. I have tried the find and replace but since I
can only do one number at a time the numbers get screwed up. I would
like a macro to prompt me for the two number to change it to and then
click change and have it do it. I don't want anything else in the
formula changed because each row has a different formula but they all
have the same layout. Any help I can get is much appreciated.

Chris Morton