I have filled a 2d array with values - can i find out the size of the
array WHERE Arry(1, i) = 'WB01' - for example.
TIA

I'm a beginner, so sorry for my stupid question.
I created a Macro in a file .xls.
I saved the file .xls with the format .xla (as add-in).
I put the file .xla in the directory C:\Programmi\Microsoft

I am attempting to sort data containing specific characters and delete
all rows but the ones that meet the critera.  Such as search for "LW"
and get all LWLI, LWOS, LWSC, etc.
I have a macro working currently that will select one of the above and

With the ShowOpen method of the Common Dialog Control, is there a way to
have the dialog box come up with the file detail showing?
You can press the 'View Menu' icon at the upper right, and then select
'Details' to bring up the file timestamps.  But, is there a way to set that

I am using Excel 2003 I am trying to test is a sheet exist and if not
create the sheet.
I have search the and have found and edited the following in a moduel.
I have been testing this but it is always returning False. Unless

What I'm trying to do with my macro is this. I have an input box where the
user will put in text, numbers, etc. The macro automatically puts that value
in the next empty row in coulmn A. But before it does that I want the macro
to search all the previous strings in column A to ...

I'm new to VB and I've written a macro that opens a second spreadsheet,
pulls data, and then closes the spreadsheet.  What kind of code can I
put in the macro to automatically choose the "read only" option when
opening the spreadsheet and then automatically not save changes made to

Is there code that I can write into my macro that allows me to access other
Excel sessions running on my computer to transfer data into a different
session that my macro is running in?  My situation is described below:
There is a program on my computer (DataNav) that opens a set ...

How do you ignore #n/A values with macros? Can I have it only look at
numbers?  I just need a quick way to tell it to move along, and not
worry about the line with an #N/A value.  TIA
Paul

I would like to make reports in excel based on a spreadsheet
In the spreadsheet there are a lot of variables, such as name, company,
... and I would like to make a report with just a few of these
variables on a new page.

I want to insert a picture (no matter what size) into merged celles. So if
the picture in imported, it must be resized automatic to fit into the merged
celles.
Thanks for the help.

I have a master spreadsheet in which I search through a subdirectory to
update it with monthly data.
This works fine until I try to do an if statement that  checks for the name
of the worksheet in the workbook it is currently reading..  Here is the code

I'm currently able to export query results to an Excel file via the
querytable method.  It is working great... and also very fast, but it
limited to 65xxx records.  Is there any way for me to use a querytable
and to programmatically spill over to additional worksheets should I

I have ran into an odd problem with a macro.  Here is what my macro
does.  It copies named ranges within a file to a presentation as a
picture. This works wonderfully except lately I have one file that even
though the named range covers the right cell range that I desire the

Ladies and Gents,
Hoping I can get some help here. I listed something similar previously
(didnt get any replies) as I didnt explain myself very well. Sorry if I
offend reposting a slightly modified post....