Re: $$Excel-Macros$$ Re: Filling in blank cells with names

Hi Johnny, You can find your answer simply at my facebook page, its easy and simple, Click below facebook link and enjoy the code, You may like this page for further coding and videos. www.facebook.com/Learn-Excel-VBA-128691477223095/ On Tue, Mar 13, 2018 at 1:29 AM, Johnny

Re: $$Excel-Macros$$ Re: Filling in blank cells with names

remove stop code. *Regards,* *For quick responds click here for Message * On Mon, Mar 12, 2018 at 10:59 PM, Johnny wrote: > Hi David, thanks for responding! When I run this macro, it actually does > fill the column down until it hits the second

$$Excel-Macros$$ Re: Filling in blank cells with names

Hi David, thanks for responding! When I run this macro, it actually does fill the column down until it hits the second non-blank then stops. But it did fill in the first name. Do you have an idea why it stops after the first non-blank? On Monday, March 12, 2018 at 1:15:24 PM UTC-4, who wrote:

$$Excel-Macros$$ Re: Filling in blank cells with names

Sorry, copy and paste missed the "S" in first line of Sub and simply says "ub". Thanks, David On Sunday, March 11, 2018 at 9:20:14 AM UTC-7, Johnny wrote: > Hi all, > > As an example, I have the name "John" in cell C4. Further down in C8 I > have the name "Jeff". Using a VBA script, I'd like

$$Excel-Macros$$ Re: Filling in blank cells with names

See if this might not work for you. Thanks, David ub NamesCopy() With ActiveSheet LastRow = .Cells(.Rows.Count, "C").End(xlUp).Row End With Range("C1").Select LoopTop: Do Until ActiveCell.Row = LastRow If ActiveCell.Offset(1, 0).Value = "" Then Selection.Copy