I have an array(Variant) of values.
I would like to show them as a list in the excel worksheet.
How do i do this? I am a newbie!!

Hi,
I have the 1000 different excel file, each file have multile no of
sheet in it. but all the 1000 different file have the same format, only
the no of rows in each files will change but the no of columes remain

i have an excel-project with a separate xml file where config
information is stored. this xml is reference through a public constant
with an absolute path, like that:
Public Const strXMLFile As String = "D:\Documents and

I need to figure out a way to look at a range of cell values (all numbers)
and return the cell number of where it falls within the list.
Reference list in Column X (X3:x25000)
# to look for in Cell Z10

I have multiple spreadsheets with varying print ranges that change monthly.  
I'm trying to figure out the macro using sendkeys, but not working very well.
Any suggestions?

Hey guys,
I have a code that when I use a bar code scanner it drops the code into a
cell say A1. I would like the bar code to be directly dropped into a text box
in the user form I have made in VBA. Any sugestions?

Dear Experts - first if you respond many thanks and im sorry if this is a
poor question
i have an excel sheet with many rows and i would like to use a loop which
processes the row in a similar manner to a classic Print statement possibly

We built a Excel VBA application. We noticed however, that a command
button displays diferently from one PC to another PC with the exact
same Excel version. The problem is that the text on the Button is
cutoff on one Pc; but displays in its enitety on another PC.  BTW-- the

Hi everyone, things are coming along slowly but surely with regards to
learning VBA to thew point where I'm considering learning VB. However,
I see things such as VB6 and VB.Net and I wondering how much difference
is there and which, if either, would be best to focus on to start ...

Hi. I know how to use VBA to have Access write a table to Excel. But how do
you write rows of data from Excel to Access?
Thanks

Simple Question I hope.....not for me obviously.
I have a field that puts in the current month formatted as 02.  I need
to take that number and multiply it by a payment to get a current
balance due for the year.

I have an Excel VB program that needs the folder path to locate various
files.  Currently I have to type in the exact path into a textbox in my
forms.  This is subject to numerous errors and file not found.  I would like
to replace the TextBox with a ComboBox in the form that ...

I want to run a macro when the user clicks in a specific cell.  In a
personal worksheet I put a button on the page and tied a macro to the
button.  In that case there was only one button.  In the present case, the
macro needs to do different things depending on what row is clicked.

how do you name a cell, not lable it but name it
--
pinehea
-----------------------------------------------------------------------

I have at least two queries in my workbook that I would like to auto refresh
via a Command Button. Can anyone provide a method to do this?
Thank you
David Morrison