Microsoft Office Forums - View Single Post - [Solved] How to write a macro for inserting a formula in an Excel cell such that its components be p

Thread: [Solved] How to write a macro for inserting a formula in an Excel cell such that its components be p

View Single Post

Old

04-18-2022, 07:50 PM

soroush.kalantari soroush.kalantari is offline

soroush.kalantari is offline

soroush.kalantari uses Windows 10

Windows 10 soroush.kalantari uses Office 2016

soroush.kalantari uses Office 2016

Office 2016

Competent Performer

The original poster

Join Date: Jun 2021

Posts: 115

soroush.kalantari is on a distinguished road

Default

Quote:

Originally Posted by p45cal

View Post

Code:

Sub insertformula()
cell01 = ActiveCell.Address(0, 0)
cell02 = ActiveCell.Offset(1, 0).Address(0, 0)
Range("c1").Formula = "=" & cell01 & "+" & cell02
End Sub

Thank you very much. Your reply solved the problem.

Reply With Quote