View Single Post
  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.