Thread
:
Increment value in a Formula
View Single Post
#
2
Posted to microsoft.public.excel.misc
Bob Phillips[_4_]
external usenet poster
Posts: 834
Increment value in a Formula
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
Reply With Quote
Bob Phillips[_4_]
View Public Profile
Find all posts by Bob Phillips[_4_]