How do i put the last value of a loop from a vba program into a cell in excel

N

ncarbone

New Member
Joined
Feb 12, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
i have a do while loop w a nested if statement, it is for iterations for the bisection method for finding the root of an eq. i woud like to know how to put the last iteration in cell C2 please an thank you
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
also if anyone knows how to fix the function lmk
 

Attachments

  • vba help.JPG
    vba help.JPG
    119.9 KB · Views: 12
Upvote 0
You must log in or register to reply here.

Similar threads

JeffGrant
  • Solved
Looking for a VBA loop suggestion.
Replies
2
Views
188
JeffGrant
JeffGrant
J
  • Solved
Selenium VBA - loop to align new data with old data in worksheet
Replies
8
Views
324
Anthony47
A
T
  • Question Question
How do you compress all pictures in Excel with VBA?
Replies
5
Views
2K
Logit
Logit
B
  • Question Question
Excel VBA Searching Unique Variables to Match against Exported Schedule Files to Determine Date
Replies
1
Views
124
sijpie
sijpie
J
  • Solved
OR function does not work in Do while loop
Replies
5
Views
316
Joe4
Joe4

Forum statistics

Threads
1,223,236
Messages
6,170,917
Members
452,366
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top