Re: $$Excel-Macros$$ simple macro??

2017-06-06 Thread Frits S
the name specific to this worksheet. If you choose "Workbook" then it will be a WorkBOOK name). Thank you for your solution, works fine! Op dinsdag 6 juni 2017 21:07:08 UTC+2 schreef Frits S: > > Thank you for your solution. > How can I name the range: "...in a column and

Re: $$Excel-Macros$$ simple macro??

2017-06-06 Thread Frits S
Rng > End Sub > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you c

$$Excel-Macros$$ simple macro??

2017-06-06 Thread Frits S
I need a macro for a simple question: In my Excel sheet I have a value in cell F5 which gives a result in cell F77. Now I want to calculate each value in F5 (from 1 to 100) to the associated value in cell F77 in two new columns: value F5=1->value F77=..., value F5=2->value F77=... (etc.) Is