loop

[Josh_123456]

Here is my current code (just a section)


Is there a loop that could possibly do this faster. Sometimes I load 100's of fields on the userform

Please Login or Register  to view this content.

Thanks for any help


Josh

[mudraker]

I suggest you use a serch function - much quicker than loops.

I aslo suggest you do not activate and select sheets, columns, rows, cells etc which also slows macros down. Your use of offset shows you just one way of dealing with cells without selecting them.

Try this code

Please Login or Register  to view this content.

[Josh_123456]

I am in the process of converting my code to the new code.


thanks for the help


Josh

[Josh_123456]

I tried the code and I am getting a runtime error message of 424


Object required.


And it highlights the section where you are setting rfound.



thanks for any help


Josh

[Josh_123456]

Thanks


Josh

[mudraker]

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.