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

2014-09-23 Thread Paul Schreiner
can you give me an example? I tried a couple of things to see if it could get VBA to act up. No luck... seems to work fine in Excel 2010. 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

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,

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 schreiner_p...@att.net wrote:

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

2014-09-18 Thread josua sitinjak
Good morning MS EXCEL AND VBA MACROS member. I'm newbie in macros. I would like to ask something. Please help me, I want to loop in a value in different sheet in a workbook at macro excel. ex : I want to compute x value in sheet 2, but to compute the x value, i need y value in sheet 1. I have

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 +