replace Range("A1:B334") with Selection
regards
r
2010/12/6 vebhav jain
> Hi All,
>
> I am facing error when the range data changes from (B334) and i need to
> adjust manually the total number, so can you suggest any better way.
>
>
>
>
>
> Thanks,
> Vebhav
>
> --
>
> -
Do you have other data beyond row 334?
Is there any reason you can't sort A1:B65000 ??
Paul
>
>From: vebhav jain
>To: excel-macros@googlegroups.com
>Sent: Mon, December 6, 2010 8:41:14 AM
>Subject: $$Excel-Macros$$ Error in Code
>
>Hi All,
>
>
>I am facing error when the range data changes fr
