Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

macro

0

nsh.Cells(148, 5).Formula = Int(settings.Range("G" & i) * nsh.Cells(146, 5).Value)

the above code gives a hardcoded output, how to get the formula the in the cell.

excel
MS Office Version: 2019
posted by: Chirag saswat on Wed Mar 9, 2022 at 5:48 am
Answer
Discuss

Answers

0

Your code is just missing some quotation marks. Change your code to the following:

nsh.Cells(148, 5).Formula = "=Int(settings.Range("G" & i) * nsh.Cells(146, 5).Value)"

The needed changes are in bold.

posted by: WillieD24 (rep: 547) on Sun Mar 20, 2022 at 10:47 pm
Discuss

Discussion

Agreed Willie. I already gave a similar answer to Chirag's duplicate question here: macro. It got no response from Chirag so hope you have better luck. 
John_Ru (rep: 6142) Mar 21, '22 at 6:51 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login