for each loop

**jeffersonss** · 09-25-2019, 03:51 AM

can help me to shorten this ??

Please Login or Register  to view this content.

**TMS** · 09-25-2019, 04:02 AM

Instead of

Please Login or Register  to view this content.

you can use

Please Login or Register  to view this content.

That means you can introduce a column counter, for example, lCol
Then you can use

Please Login or Register  to view this content.

**ikboy** · 09-25-2019, 04:22 AM

Please Login or Register  to view this content.

**WideBoyDixon** · 09-25-2019, 05:09 AM

Please Login or Register  to view this content.

WBD

**jeffersonss** · 09-25-2019, 05:34 AM

thanks to you wideboydixon.. you're the best more power!!!

**jeffersonss** · 09-25-2019, 05:36 AM

can you help me more with this sir wideboydixon??

Please Login or Register  to view this content.

**Norie** · 09-25-2019, 05:55 AM

Try this.

Please Login or Register  to view this content.

**jeffersonss** · 09-25-2019, 05:58 AM

ill try this one tomorrow sir because i will be out today and will continue tomorrow .. thanks again for spending time to my thread man.. hoping to know you more .. more power and god bless !!

**WideBoyDixon** · 09-25-2019, 10:03 AM

Please Login or Register  to view this content.

WBD

**Trebor76** · 09-25-2019, 06:24 PM

Note this has been cross-posted here.

**jeffreybrown** · 09-25-2019, 06:37 PM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

**jeffersonss** · 09-25-2019, 09:50 PM

sorry forposting it twice and sorry for not reading the rules here

i won't do such thing like this again .. thanks for reminding ..

**jeffersonss** · 09-25-2019, 09:52 PM

WideBoyDixon thank you so much for helping my work .. I am hoping to learn more about looping

still have last problem regarding to my code

Please Login or Register  to view this content.

**jeffreybrown** · 09-26-2019, 07:07 AM

Originally Posted by jeffersonss

sorry forposting it twice and sorry for not reading the rules here

i won't do such thing like this again .. thanks for reminding ..

Hi jeffersonss,

This was not a reminder, this was a request for you to comply with the instructions about annotating a cross post so others can follow where the cross post exists.

**jeffersonss** · 09-26-2019, 09:07 PM

HI jeffreybrown,

okay, I understand now

**WideBoyDixon** · 09-27-2019, 03:55 AM

Please Login or Register  to view this content.

WBD

**jeffersonss** · 09-27-2019, 04:25 AM

thank you so much senpai

**jeffersonss** · 09-27-2019, 04:32 AM

i have an error in my oblbl .. it says that type mismatch

Please Login or Register  to view this content.

**WideBoyDixon** · 09-27-2019, 10:05 AM

That could happen if the current caption on the control is not a number. However, the existing code made the same assumption.

WBD

**jeffersonss** · 09-30-2019, 08:56 PM

any solution for this problem WBD? Have a nice day by the way Mr. WideBoyDixon

**WideBoyDixon** · 10-01-2019, 03:56 AM

Not without getting a copy of the workbook. I can't work blindfolded

WBD

for each loop

LinkBack

Thread Tools

Rate This Thread

Display

for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Re: for each loop

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA to loop through cell-defined range and paste table output after each loop.

Loop through a data validations list and for each loop count the number of occurences

[SOLVED] (Beginner help) For loop inside do loop that displays information from reference sheet.

[SOLVED] Auto email loop with formatted table data breaking on second loop VBA

[SOLVED] VBA to loop within a loop of multiple blocks of data (currentregion) ... Expert needed

[SOLVED] Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)

Why did an inner loop variable start overwriting the outer loop range suddenly?

Bookmarks

Bookmarks

Posting Permissions