Need to create a loop for already working process. Should be easy!

**needshelpwithexcel** · 10-24-2016, 05:13 PM

Hi. I need help looping this process for each row until there is a blank value in the A column. I have found many loop codes online but have not been able to make it work for this simple macro. Any help please!?

Thanks!

Please Login or Register  to view this content.

**AB33** · 10-24-2016, 05:31 PM

untested.

Please Login or Register  to view this content.

**needshelpwithexcel** · 10-24-2016, 09:08 PM

Worked like a charm! Mind sharing what I was doing wrong? Thank you

**needshelpwithexcel** · 10-25-2016, 08:04 PM

Hi. Anyone's know how to change the .Display to .Send without the macro losing the HTML formatting? The emails that are being sent need to have a signature with each and therefore need the .html format to stay when the loop is changed Tom.send

Need to create a loop for already working process. Should be easy!

LinkBack

Thread Tools

Rate This Thread

Display

Need to create a loop for already working process. Should be easy!

Re: Need to create a loop for already working process. Should be easy!

Re: Need to create a loop for already working process. Should be easy!

Re: Need to create a loop for already working process. Should be easy!

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Using muitiple ranges within a loop to process if function..

Repeat or Loop Process for each value in a list for saving new filesin VBA

[SOLVED] how can I take the value of several selected cells and process them in a loop ?

Spawn a child process? to run the loop, then move on

VBA to create specific named ranges and repeating process (Loop?) across columns

Hopefully an Easy Fix: Working formula not working when applied to other worksheets

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions