LinkBack URL
About LinkBacks
I have a repetitive code that skips every 20 lines and starts on C21 and goes goes to C2921. I'm sure there is a way to shorten this code, I just do not know how.
I appreciate the help.
Please Login or Register to view this content.
I have a repetitive code that skips every 20 lines and starts on C21 and goes goes to C2921. I'm sure there is a way to shorten this code, I just do not know how.
I appreciate the help.
Please Login or Register to view this content.
Are you asking how to loop through the code from 21 to 2921?
Please Login or Register to view this content.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Hi, pasqualebaldi,
maybe like this:
BTW: the code works only on Column A, where is the relation to Column C as you give up that range?Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
I'm sorry, when one of the cases are picked it pastes data in column C. I meant to say column A.Originally Posted by HaHoBe
Hi, pasqualebaldi,
maybe like this:
BTW: the code works only on Column A, where is the relation to Column C as you give up that range?Please Login or Register to view this content.
Ciao,
Holger
Thank you very much! This worked perfectly and it is much less code than what I had!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks