ExcelBanter - How to change the value in different rows using the same cell to e

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to change the value in different rows using the same cell to e (https://www.excelbanter.com/excel-programming/347018-how-change-value-different-rows-using-same-cell-e.html)

b14_rebel

How to change the value in different rows using the same cell to e

=A34+C36, +A34=B36, and A34 changes every column

chijanzen

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

All times are GMT +1. The time now is 10:02 PM.