ange,"-")
and use:
if ((Cells(I,1) >= NumArray(0)) and (Cells(I,1) <= NumArray(1))) then
From: Joe Wilson
To: excel-macros@googlegroups.com
Sent: Thursday, April 30, 2009 8:52:04 AM
Subject: $$Excel-Macros$$ Re: Consolidate Macro
Paul, thanks...that work well, but how do I se
quot; & I).EntireRow.Hidden = True
> End If
> Next I
> End If
> End Sub
> '==
>
>
> --
> *From:* Joe Wilson
> *To:* excel-macros@googlegroups.com
> *Sent:* Wednesday, April 29, 2009 1:57:04 PM
> *Subject:* $$Excel-Macros$$ Re:
True
End If
Next I
End If
End Sub
'==
From: Joe Wilson
To: excel-macros@googlegroups.com
Sent: Wednesday, April 29, 2009 1:57:04 PM
Subject: $$Excel-Macros$$ Re: Consolidate Macro
Paul,
Thanks for the response. In the spreadsheet, there is
Paul,
Thanks for the response. In the spreadsheet, there is a number holder for a
name to be added later. It's because we have so many linked files and we
add rows for future additions to the model.
So, there are probably 20 instances where I have rows that go from 3 to 18
and instead of going
I'm not sure if I understand how you're determining "rows that start with the
number 3 and goes to 18 or higher"
What does "start with number 3" mean?
is the cell in column "A" a number?
Is it always the same as the row number?
or are you saying you want to hide rows that have the number 3,
30,3
