I have a question that concerns the CurrentRegion of a worksheet.
I execute the following code to find the last row in the workbook:
   activecell.specialcells(xllastcell).select
   set ocurrentregion = selection.currentregion

Can anyone tell me why the line   rng(1, 4) = "X"   below returns a Type Mismatch error? This should place an X in the 4column over from the
Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
   Dim SH As Worksheet

i am using this =VLOOKUP(F1,TiedEquip,4,FALSE) on my worksheet and it
is located in D1, what i would like to do is a VLookup like
this.....=VLookup(F1,C1 ,4,FALSE), where C1 on the same sheet would be
the name of the named range to look at, this way i can have a drop down

I want to create a string that depends on the number of items in a
list.
For example, say my list looks like the following:
(a1)  baseball

Ok I have one main data sheet and I am looking for a macro to split that
sheet into many spreadsheets.
Each set of data is seperated by a blank row. Data sets are variable.
I have attached 2 spreadsheets to show what i start with and what I am

I currently am working on a fairly large sheet where i want to extract/copy
data to another area using two different criterea. currently it seems to be
copying all the data. Any suggestions will be appreciated
Sub DataM()

I have this brilliant piece of code that I picked up from Ron de Bruin web
site, that unzips a file and saves as unzipped.
Sub Unzip()
   Dim oApp As Object

I have used the VBA function IsString in the past and I do not remember
any problems. I have upgraded to Office 2003 and suddenly I can not test
if a member of a record set is a string. Please tell me if there is a new
or another old way that still works.

I have some code that selects a named range and then copies it to a
location, is it possible to select the named range but just copy the
first 18 rows x 2 columns out of it, so if the named range dimension
was 18x4 just copy the contents of the named from columns A & B and

I've tried succesfully to call a batch macro from excel with the shell
command.
But when I add parameters to the shell pathname it does not work.
assume the batch file x.bat content is:

Could someone please help me write a macro that changes the colorIndex of a
cell based on it's value.  I want all positive numbers in my selection to be
green and all negative numbers to be red... this should be easy but I need
help!

Does someone have a function to sort the values in an array?

Does anyone know how to retrieve the value from a cell and store it i
a variable ?
What I want to do is, create a loop to look at the data in each cell i
row "C"

I know how to count rows:
lgLastRow = Workbooks(2).Sheets(pbFundSheetNo).Cells(Rows.Count,
"A").End(xlUp).Row
Can the same code be adapted to count the number of used columns?

Any method to create dynamic UI sheet or UI Form?