On Tue, 3/20/18, Rabindra Thapa wrote:
Subject: Re: $$Excel-Macros$$ Re: Filling in blank cells with names
To: excel-macros@googlegroups.com
Date: Tuesday, March 20, 2018, 10:40 AM
remove stop
code.
Regards,
For quick
responds click
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 wrote:
> Hi David
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 non-blank then stops.
> But it did fill in the
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:
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 to
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
ActiveCel
