VBA Cells Formula - Code Included

Описание к видео VBA Cells Formula - Code Included

Grab the Free VBA Quick Reference Guide
https://chrisjterrell.com/p/getting-s...
Adding a formula in to a cell in Excel is fairly easy in this video you will see how to send a formula to a cell using the standard formula notation and the R1C1 notation

Code
==================
Sub AddFormula()

Range("B10") = "=Sum(A9:A15)"

Range("B11") = "=Sum(R[-2]C[-1]:R[9]C[-1])"

End Sub

Комментарии

Информация по комментариям в разработке

Похожие видео