Change Row Numbers in Formula with Macro
 

=IF(February!I16=0,"",February!I16)

I am using this formula but would like to develope a macro
to update the Row number(16) to Row number(17)
automatically. I do not wish to change anything except
the Row number and am not sure how to do this.


Any help is greatly appreciated. Thank you

Frank

Hi
why not use 'Edit - Replace' for this?

--
Regards
Frank Kabel
Frankfurt, Germany
"Frank" schrieb im Newsbeitrag
...
=IF(February!I16=0,"",February!I16)

I am using this formula but would like to develope a macro
to update the Row number(16) to Row number(17)
automatically. I do not wish to change anything except
the Row number and am not sure how to do this.


Any help is greatly appreciated. Thank you

Frank

Sub test()
Dim cell As Range
Set cell = Sheets("Sheet2").Range("F7")
cell.Replace What:="16", Replacement:="17"
End Sub

---
HTH
Jason
Atlanta, GA

-----Original Message-----
=IF(February!I16=0,"",February!I16)

I am using this formula but would like to develope a
macro
to update the Row number(16) to Row number(17)
automatically. I do not wish to change anything except
the Row number and am not sure how to do this.


Any help is greatly appreciated. Thank you

Frank
.

Thank you it is working very well, they were both
excellent sugestions.

Frank
-----Original Message-----
Hi
why not use 'Edit - Replace' for this?

--
Regards
Frank Kabel
Frankfurt, Germany
"Frank" schrieb im
Newsbeitrag
...
=IF(February!I16=0,"",February!I16)

I am using this formula but would like to develope a
macro
to update the Row number(16) to Row number(17)
automatically. I do not wish to change anything except
the Row number and am not sure how to do this.


Any help is greatly appreciated. Thank you

Frank


.