Prev: Keeping the format but update the data
Next: How do I get warpped data to auto fit in merged cells?
From: p45cal on 29 Apr 2010 12:40

Good!
On reviewing the code jut now, I notice I left some debugging lines that
really oughtn't to be there, so please remove these:

Rows(i).Select
cll.Select

they'll slow it down.



S
t
e
v
e
;
7
1
2
7
4
6

W
r
o
t
e
:


>
That is nothing short of amazing. THANK YOU very much.
>
> As you probably ascertained, the end down did go to the last row.
>
> And I'm assuming you won't mind, but I did take the liberty to change
the
> name of the macro from blah to kudos.
>
> Many thanks gain,
>
> Steve
>
>


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=199126

http://www.thecodecage.com/forumz

From: Steve on 29 Apr 2010 15:10
Thank you again.

Steve

"p45cal" wrote:

>
> Good!
> On reviewing the code jut now, I notice I left some debugging lines that
> really oughtn't to be there, so please remove these:
>
> Rows(i).Select
> cll.Select
>
> they'll slow it down.
>
>
>
Steve;712746 Wrote:
> >
> That is nothing short of amazing. THANK YOU very much.
> >
> > As you probably ascertained, the end down did go to the last row.
> >
> > And I'm assuming you won't mind, but I did take the liberty to change
> the
> > name of the macro from blah to kudos.
> >
> > Many thanks gain,
> >
> > Steve
> >
> >
>
>
> --
> p45cal
>
> *p45cal*
> ------------------------------------------------------------------------
> p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
> View this thread: http://www.thecodecage.com/forumz/showthread.php?t=199126
>
> http://www.thecodecage.com/forumz
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Keeping the format but update the data
Next: How do I get warpped data to auto fit in merged cells?