Thread
:
Increment value in a Formula
View Single Post
#
7
Posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 35,218
Increment value in a Formula
It takes too long to select the range to fix
Edit|Replace
what: $1686
with: $1698
replace all
David Marr wrote:
Because it takes too long as i have a vast amount of data.
Dave
"Bob Phillips" wrote:
Why not just use Find & Replace, Ctrl-H?
--
HTH
Bob
"David Marr" <David
wrote in message
...
Hi,
I'm using Excel version 2003.
I have the following formula =IF(SUM('Section
3'!$H$1675:$J$1686)=0,"",SUM('Section 3'!$H$1675:$J$1686)) and would like
to
increment the cell references by 12.
I was wondering if there is a way to do this using a bit of VBA code?
So the result i'm looking for after code run is =IF(SUM('Section
3'!$H$1687:$J$1698)=0,"",SUM('Section 3'!$H$1687:$J$1698)).
I will be running the formula along the columns so will need to increment
the formula by 12 for each new column.
Thanks
Dave
.
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson