Hi Mike,
Thanks for the feedback
Dave.
> Date: Mon, 23 Nov 2009 14:56:57 -0800
> Subject: Re: $$Excel-Macros$$ Add a column of matching numbers
> From: mwillia...@socal.rr.com
> To: excel-macros@googlegroups.com
>
> Dave,
> Your soultion was spot on.
> It executed
> End Sub
>
> Regards - Dave.
>
>
>
>
>
> > Date: Fri, 20 Nov 2009 16:28:50 -0800
> > Subject: $$Excel-Macros$$ Add a column of matching numbers
> > From: mwillia...@socal.rr.com
> > To: excel-macros@googlegroups.com
>
> > What I need to do is insert
own).Row, 1)), Type:=xlFillDefault
> End Sub
>
> Regards - Dave.
>
>
>
>
>
> > Date: Fri, 20 Nov 2009 16:28:50 -0800
> > Subject: $$Excel-Macros$$ Add a column of matching numbers
> > From: mwillia...@socal.rr.com
> > To: excel-macros@googlegroups.
quot;).AutoFill Destination:=Range(Cells(1, 1),
Cells(Range("B1").End(xlDown).Row, 1)), Type:=xlFillDefault
End Sub
Regards - Dave.
> Date: Fri, 20 Nov 2009 16:28:50 -0800
> Subject: $$Excel-Macros$$ Add a column of matching numbers
> From: mwillia...@socal.rr.com
> To: exce
What I need to do is insert a column at A:A
if there is data in B1 number A:1 as 1
down one to B2 number A:2 as 2
and so on to the end of data in column B
start with this
Col A
aaa
bbb
ccc
end with this
Col A Col B
1.aaa
2.bbb
3.ccc
(dots shown here as spacers)
The co
