Thread: How to change the value in different rows using the same cell to e
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
chijanzen chijanzen is offline
external usenet poster
  
Posts: 139
Default How to change the value in different rows using the same cell to e
b14_rebel:

try, Replace

Cells.Replace What:="A34", Replacement:="B36", LookAt:=xlPart, _
MatchCase:=True

--
天行健，君*以自強不息
地勢坤，君*以厚德載物

http://www.vba.com.tw/plog/


"b14_rebel" wrote:

=A34+C36, +A34=B36, and A34 changes every column
Reply With QuoteReply With Quote