i am using excel to calculate my stake sizes based on previous races wins/ loses ,(each event calculation has a dedicated row), i then want Excel to send this stake size cell to the dedicated event sheet. The issue i have is how do i get excel to only execute the calculation in row number 4 after rows 1,2,3 have executed ?. In other words how can we make excel calculate the rows in a consecutive manner ?.
I am grateful for any comments ,ideas.
execute each row calculations in a consecutive manner
-
finnbarr99
- Posts: 35
- Joined: Sat Jun 27, 2009 1:17 pm
Hi Jon
You need to use a For Each Next loop.
Syntax is
This will loop through each cell in turn and execute actions.
Id recommend you buy a VBA book to help you. Also check out microsoft.excel.public.programming newsgroup. Most of the stuff you need has already been asked and answered on there. You just need to search through on a keyword and you'll find code snippets that you can cut/paste/modify to your own ends.
You need to use a For Each Next loop.
Syntax is
Code: Select all
For Each [element] In [group]
[instructions]
[Exit For]
[instructions]
Next [element]Id recommend you buy a VBA book to help you. Also check out microsoft.excel.public.programming newsgroup. Most of the stuff you need has already been asked and answered on there. You just need to search through on a keyword and you'll find code snippets that you can cut/paste/modify to your own ends.