Klartigue
02-29-2012, 09:09 AM
Basically, for each item highlighted, A1, A2, A3, A4..etccc..I calculate the impact of the trade by multiplying Spread*Amount*10. So can you help me write a VBA code that calculates the impact for each item highlighted? Now there could be 20 items highlighted or there could be 8 items highlighted, it will always differ so I need a code that does this for all items highlighted, and then place the results two lines below the last line.
Thanks for the help! ... You all helped me write a code that generated the top part of this spreadsheet and I use it all the time, so helpful!!!
Thanks for the help! ... You all helped me write a code that generated the top part of this spreadsheet and I use it all the time, so helpful!!!