insert loop

**fruitloop44** · 10-29-2022, 10:40 PM

hello,

my individual_VaR macro works. if you press clear button and then run button, it populates the corrects cells w the correct values.

is there a way i can put a loop into the sub so it will create this table for each instrument in my market data tab?

the homework_desired tab is how id like the sub output to be

thank you

VBA_Section4HW_v2_loop.xlsm

**jindon** · 10-30-2022, 12:22 AM

Please Login or Register  to view this content.

**Sintek** · 10-30-2022, 07:45 AM

Another Option

Please Login or Register  to view this content.

**fruitloop44** · 10-30-2022, 01:23 PM

this worked perfectly! thank you
can you provide some commenting so it is easier for me to follow please?

insert loop

LinkBack

Thread Tools

Rate This Thread

Display

insert loop

Re: insert loop

Re: insert loop

Re: insert loop

Thread Information

Users Browsing this Thread

Similar Threads

Loop to insert rows

[SOLVED] insert row in a for next loop macro

Cut and Insert loop help

Insert rows (loop)

Loop until Sum equals Zero ($0.00) - then Insert Row

Using Loop to insert a row

Bookmarks

Bookmarks

Posting Permissions