Losing the plot with vba
Closed
thebear3866
Posts
3
Registration date
Friday January 10, 2014
Status
Member
Last seen
January 10, 2014
-
Jan 10, 2014 at 05:26 PM
Blocked Profile - Jan 10, 2014 at 07:47 PM
Blocked Profile - Jan 10, 2014 at 07:47 PM
Related:
- Losing the plot with vba
- Vba case like - Guide
- Number to words in excel formula without vba - Guide
- How to open vba in excel mac - Guide
- Vba check if value is in array - Guide
- Vba color index - Guide
4 responses
"bear",
So, where is the failure? We can help, but do not wish to duplicate what you have already completed, what do you need help with?
So, where is the failure? We can help, but do not wish to duplicate what you have already completed, what do you need help with?
thebear3866
Posts
3
Registration date
Friday January 10, 2014
Status
Member
Last seen
January 10, 2014
Jan 10, 2014 at 06:59 PM
Jan 10, 2014 at 06:59 PM
sorry, it keeps coming up with "compile error: loop without do"
Bear,
Standby
<strike>It is your second loop statement!</strike>
OK, try not to use GOTO statements!
I believe, you are exiting the loop with the goto, and therefore, the loop breaks.
Whatever you want goto to perform, make it a seperate function or routine, and have it return the value back inline!
So it would look like:
activecellcolor=6
changethecolor(activecellcolor)
instead of:
ActiveCell.Interior.ColorIndex = 6
GoTo SKIPPING
Now build a subroutine called changethecolor(whatcolor) that accepts the whatcolor variable and places it into the activecell.interior.colorindex property.
Try that!
//ark
-Moderator/Contributor
Standby
<strike>It is your second loop statement!</strike>
OK, try not to use GOTO statements!
I believe, you are exiting the loop with the goto, and therefore, the loop breaks.
Whatever you want goto to perform, make it a seperate function or routine, and have it return the value back inline!
So it would look like:
activecellcolor=6
changethecolor(activecellcolor)
instead of:
ActiveCell.Interior.ColorIndex = 6
GoTo SKIPPING
Now build a subroutine called changethecolor(whatcolor) that accepts the whatcolor variable and places it into the activecell.interior.colorindex property.
Try that!
//ark
-Moderator/Contributor
thebear3866
Posts
3
Registration date
Friday January 10, 2014
Status
Member
Last seen
January 10, 2014
Jan 10, 2014 at 07:40 PM
Jan 10, 2014 at 07:40 PM
thats cool it is doing something but it isn't copying rows over, i am an absolute newbie at vba and apart from the sheets and range names i haven't a clue whats going on, i'm trying to get this workbook working so that the three team managers can sit down and then when they decide who goes where, it auto populates each sheet.
thank you so much for your help so far
thank you so much for your help so far
bear,
It is getting late where I am at, so I am going to dream about it tonight.....
Keep doing what you are doing....
Make each seperate thing work on its own! I am certain by the end of the night you would be able to "script" the whole thing together, just by googling different "components" of your solution!
Have Fun.
It is getting late where I am at, so I am going to dream about it tonight.....
Keep doing what you are doing....
Make each seperate thing work on its own! I am certain by the end of the night you would be able to "script" the whole thing together, just by googling different "components" of your solution!
Have Fun.