Could someone run the following code in Excel2007 with n=65535 and then
n=65537 and report the results?
Sub abtest1
    Dim arr1(), arr2(), iVar, n

Hey, I have a workbook with many worksheets. I am trying to write a
macro to search all the worksheets for a unique value. I have a
userform to enter the value and assign it to a variable. I just need
to search all sheet for that string, and if that string exists in a

I have a list in excel that needs to be printed within a certain space
variable data.
Is there a way to set up a formula/macro that will change the font size if
there are more than say 60 characters but leave any less than 60 characters

I have searched this site for several hours, but I am not able to find the
answer I am looking for. I'm a novise om VBA - maybe that's why?
I need to [copy + paste special, value] the value of K1 [=NOW()] down to the
first empty cell in column J. Column J has got blank cells so ...

Can anyone take a look at the code please and help me figure out why
it's skipping every other "elfseif" statement?
lets say I have these values on each row (its a copy and paste from a
dumb terminal) which I'm trying to reformat in Excel because we can't

My VB editor window mysteriously keeps poping up.  I am not even working with
the editor at the time but it will pop up with no particular macro/module to
view.
I work with the editor via Excel and Access to create or edit code but never

Can someone kindly tell me how to specify a range within a 2-dimensional
array (e.g., row 1, column 1 through row 1, column 14)?  I'm trying to do so
in the following VBA line:
RowHourCellsFound = WorksheetFunction.CountIf(Range(HoursArray(1, 1) & _

Hey, I have a workbook with many worksheets. I am trying to write a
macro to search all the worksheets for a unique value. I have a
userform to enter the value and assign it to a variable. I just need
to search all sheet for that string, and if that string exists in a

I am looking to convert a set of numbers into text (ex. 621163578733 =
Product Name).  I would like to do this in such a way that I can enter
multiple numbers and have each number display the product name. Any
help here would be great.

I have a file that is marked as recommended read only. I would like to have
my macro open the file alter it and save it but I can't seem to automatically
get rid of the message box when I open the file that asks if you would like
it to be read only.

I'm trying to refer to a named cell in a table in some VBA code for an
Excel 2007 workbook.  I used the "create from selection" feature in
Excel 2007 to create the names for the range. The names are based on
the left columns and the top row, so I should be able to reference any

I am interested in creating a list of the names of the worksheets in a
workbook which has been selected using the Application.GetOpenFilename
dialog.  How would I go about doing this?
Thanks in advance for your help!

I use the End(xldown).Row for splitting up a a file on import.
With ActiveSheet
   LastCell8 = .Range("h1").End(xlDown).Row
    .Range("m1").Copy

Need a hint how to get a string from a variant array.
The code I'm using (Excel 2003):
Dim MyArray(5) as variant
MyArray = array("help",1,2,3,4)

I have a x rows of 5 fields (name and home addresses)
The first 2 fields must have data.
How would I check if the first 2 fields have data and if not check
fields 3,4 and 5 for data and if exits move them to the fields 1 or 2.