Err, the link doesn't show up completely in this e-mail. It is the
Test_DeleteByNumberName file in the list of uploaded files.
On Jun 9, 12:25 pm, molinari wrote:
> Thanks a lot, Deepak.
>
> Here's the
> file:http://groups.google.com/group/excel-macros/web/Test_Delete
ou.
>
> Regards,
>
> Deepak
>
>
>
> On Tue, Jun 8, 2010 at 8:35 PM, molinari wrote:
> > I have a list of reports to be printed out Monday - Friday, where each
> > worksheet is Monday, Tuesday, Wednesday, Thursday, or Friday. I made
> > another worksheet
I have a list of reports to be printed out Monday - Friday, where each
worksheet is Monday, Tuesday, Wednesday, Thursday, or Friday. I made
another worksheet to list reports that we no longer need (by their
report number). I want the macro to go through the worksheet and
delete the rows that corres
certain tabs (and does a certain filter), based on the contents of the
SBU array variable.
On Jun 4, 11:42 am, Paul Schreiner wrote:
> if you'll show me the code you're using,
> I'll rewrite it to access the cells directly.
>
> Paul
>
> __
CPU - time
> consuming.
>
> I may play with it and see what I can determine.
>
> thanks for the puzzle!!!
>
> Paul
>
>
> From: molinari
> To: MS EXCEL AND VBA MACROS
> Sent: Thu, June 3, 2010 12:07:32 PM
> Subject: Re: $$E
-
> In this case, the variable ClaimProviderRange works the same as any Range
> object.
>
> ClaimProviderRange(1,5).value gives you the value of cell E1
>
> what you're DOING with the array or range will determine the best method for
> defining it.
>
> hope this helps.
>
> Paul
>
header row and column, which I don't want
to have entered in, and people can add new information to the table,
which I would want to account for. I.e., I can't just tell it to add
cells A2:D10 to the array.
On May 28, 2:35 am, Stuart Redmann wrote:
> On 27 Mai, 17:08, molinari wrote:
&
Hi all, I want to create an array in VBA such that typical end-users
can modify what goes into the array without knowing code (or looking
at it). Hence, I want the array to read the contents of a worksheet,
excluding the first column and first row (which are labels).
i.e., I want to read the follo
I have a macro for which I want to eliminate repetitive code. I have
two sets of sheets, which match in different ways and are
systematically labelled. There are sheets with numbers 1 to n, which
also have a postfix "a" or "b". Different things need to be done to
the sheet depending on both the she
