Vba change multiple formulas

[ste33uka]

Hi i have lots of different formulas with range 2 to 77777
Is it possible using a vba to change the 77777 to 177777

example
=COUNTIFS($C$2:$C$77777,C161664) would change to
=COUNTIFS($C$2:$C$177777,C161664)

Thanks

 

[sykes]

Is the sheet in question, called "data"?
If so, to refer to it by name, you always need the reference to be a string - i.e. in double quotes, thus:

For Each cl In Sheets("data").UsedRange.SpecialCells(xlFormulas)

... AND it needs to be case-correct.

 

[ste33uka]

yes sheet is called data, have done double quotes and case correct
Thanks

 

[sykes]

Great.
Can you let us know if (when) it did the trick.

 

[ste33uka]

Great.
Can you let us know if (when) it did the trick.

will do

 

[ste33uka]

Great.
Can you let us know if (when) it did the trick.

forgot to say,it completed, thanks

 

[sykes]

Great! Thanks for letting us know.