Re: $$Excel-Macros$$ Loop in cell in different sheet in a workbook

2014-09-23 Thread Vaibhav Joshi
Hi Fill data in relevant cells of sheet1 to get values in sheet 2. Starring cell is C32 in Sheet 1 & after that looping is done offsetting 10 rows & 10 column. PFA, macro is working correctly Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Sep 19, 2

Re: $$Excel-Macros$$ Loop in cell in different sheet in a workbook

2014-09-23 Thread Paul Schreiner
$$Excel-Macros$$ Loop in cell in different sheet in a workbook > > > >Thank you very much Mr.Paul. >I have tried it. >Succesfull. > >Can I ask again? > >Divided by small number square 0.2, how can i get the value, because the >VBA assume it zero. Actually i d

Re: $$Excel-Macros$$ Loop in cell in different sheet in a workbook

2014-09-22 Thread josua sitinjak
Thank you very much Mr.Paul. I have tried it. Succesfull. Can I ask again? Divided by small number square 0.2, how can i get the value, because the VBA assume it zero. Actually i don't want to assume it zero value. On Fri, Sep 19, 2014 at 9:31 AM, Paul Schreiner wrote: > What is the actual

Re: $$Excel-Macros$$ Loop in cell in different sheet in a workbook

2014-09-18 Thread Paul Schreiner
What is the actual name of your worksheets? Is one actually called "Sheet1" or have you renamed it something else? For instance, if the first sheet in your workbook is called "Data", in the VBA explorer window, it will be called: Sheet1 (Data) If you want to refer to the value of Cells(32 + j, 3