Loop for repetitive code
Hi i have the following code for a large number of cells in a column, the code is so huge that i have hit the 'procedure too big' barrier so please take a look at the code below
This is just one 1/40 th part of the code and i hope you can imagine the hardship that i have to go thru to make this code work .. so I hope some kind of LOOP solution will be viable .As you can see that cells are progressing and not random which might make the job easier
Please Login or Register to view this content.
It may help to post a small sample of your workbook and detail your expected results.
Hello JackandJill,
You don't say much about what this macro is supposed to do. It would be easier to propose a solution if you gave more details about what you want to accomplish. My initial thought is the workbook layout could benefit from better design, but until you post the workbook that too is an unknown.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
===Please Login or Register to view this content.
Bascially it will update when ever there is a change in Cell C 9 to C17 while condition is true with constant in C8.
Here I am simply asking to help in writing Code as a loop as there are continues increment from 9 to 17(Column B, C, D) and another continuation number from 39 to 47 (for Column C)
..
The change will happen each time there is justification of value one after another
Hello JackandJill,
Since you are doing this formatting during the Worksheet_Calculate event, I have to ask if you have considered Conditional Formatting.
Hi,
Thanks for your quick reply,
I want to do in vba as I need to take these changes for other updates in the process after this.
so please help me to write in loop,
I just started trying my self but not working actually
here it is my trail and failed one
in this there may be more lines not needed in for loop and place where to place the loop is not clear to me ..Please Login or Register to view this content.
Please help me in making working loop
Thanks,
Is this post going to be answered or should I close?
Have you ever consulted the VBEditor's help function or some VBA book ? For instance to study the properties of For...Next with decremental values.For bcolumn = 17 To 9 Step 1
For acolumn = 47 To 39 Step 1
For ccolumn = 47 To 39 Step 1
Hi,
Thanks for suggestion, I was not able to understand even after I gone through it that's how I am expecting help from you all pros there, hope you can help me to resovle the issue.
..
Please tell me how I can build this into loop, to make less lines of the code.
.
However I am also trying my self but unsucessfull till now.
in fact I have chnaged code as below and tried
For bcolumn = 17 To 9 Step -1
For acolumn = 47 To 39 Step -1
For ccolumn = 47 To 39 Step -1
Still unsuccessful.
...
It could be very simple to you but for me it is a big resolution to get, please help.
Thanks,
Hi,
Please help me in builiding the code, much appreciated your help.
Thanks,
Is there any body could help or should I close the Thread .. pl advice
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks