« «
» »

数式の代入/取得

A1形式で数式の設定/取得
ActiveCell.Formula = “=A1+B1”

R1C1形式で数式の設定/取得
絶対参照
ActiveCell.FormulaR1C1 = “=R1C1+R1C2”
相対参照
ActiveCell.FormulaR1C1 = “=RC[-2]+RC[-1]”

www.moug.net
 
セルに数式を入力/取得する(Formula/FormulaR1C1プロパティ)：Excel VBA｜即効テク...
https://www.moug.net/tech/exvba/0050098.html

This entry was posted on 月曜日, 7月 22nd, 2019 at 1:24 AM and is filed under VBA. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.