This is hard top describe in a a title.
I would like to be working in one workbook (wb) select a cell that has any
type of data and search for that data in another wb that may or may not be
open.

I need to find a way to get the nth number of Service Groups to put in this
array or find a better way? Each sheet
has a different number. The next sheet has 200+ service groups. The service
group type

Spreadsheet "A" runs a macro that opens spreadsheet "B". It gets data and
then closes "B" without saving (other spread sheets access "B" and deposit
data). A, then uses data for report.
However, when "B" opens it runs its own macros (the code doesn't ask it to

I'm writing an application that counts values in a large selection if
they comply to a crieria of greater than Firstvalue  and smaller than
secondvalue .
The selection could be a huge Excel range, so that the speed is a very

I don't think this macro is going to work for this problem.  There are 84
service groups on this sheet and an undertermined number of service groups on
other sheets.  I'm getting a runtime subscript out of range right above the
line that fills the array but all I have to do is ...

Column H is a type field.  It is SG1, SG2, SG3, SG4....
at the end of each group I need 24 rows.
There is a runtime error on the line for If ActiveCell.Value =
ActiveCell.value

Hello... I have some clunky VB code that runs fine if I "run to cursor" in
stages, but if I try to run it complete by itself I get the following
run-time error:
Method 'Union' of object '_Global' failed.

I need to add 24 rows to each service group in column H.  The field is SG1,
SG2, SG3.  For each subtotaled group at the end I need to add the 24 rows.  
The do until range line
has an error.  I also don't know how to make the insert line add 24 instead

I dont know how easy this is but I wondered if this can be done in
code.
I need a macro to look down column A and search for an extract string
of text.

I cant seem to get going a vlookup formula to look thru different work
sheets in the same workbook, What i have is this.
=vlookup(d9,'sheet2:sheet30!',d8:g300,2,false)
How to do, to make that vlookup search thru all the workbook?  Thnx

I tried researching the group, but there wasn't any response that
exactly matched what I had in mind, or at least that I could
interpret.  I am trying to make a tally sort of similiar to the way
countif works, but I have 2 criteria instead of 1.  For instance,

Hello guys,
I'm am trying to lock all cell, and make cell content bold until the date of
today is encountered. the range contains dates in the default date format
(this is European style date formatting, thus dd/mm/yyyy). However, it keeps

I'm using Visual Studio 2005 and programming with Visual Basic so its very
similar to VBA.  I have a process that runs and compares two different
spreadsheets and does a few vlookups and some other tasks.  But when I'm
running this program I can't use excel because if I do, it ...

I need to add 24 rows to each group in column "H" that are the same.  It is
stopping
on the Do Until.  My last row is 1442.  I want it to stop there.  I don't
know how to tell it to keep going until the end.

If I sort from Column H to column A by putting a negative infront of the
letter it  isn't working.  
Dim sheet1 As Worksheet
Dim myrange As Range