Afternoon all,
Im trying to programmatically copy and paste from one workbook into another,
with two seperate bits of data pulled from seperate locations.
So i have an excel file with two tabs of data, i then want to copy and paste

I have a worksheet in which I have deleted rows at the end of the sheet in
some VBA code. In VBA I now want to find the last last row that contains
data. Some columns have data and some are blank so I don't know which column
will consistently have data.

  I have got a requirement as follows
My input data is as
A/C Code   Value
1                 100

I am using the rand() function in Visual basic to find a specific number on a
list and bring up the value from 2 cells over.  I have got all that but the
list does not contain all number from 1 to 100.  for example there is no 23
so when rand comes up with 23 the macro gets an ...

Each month I have to change the links in my workbook.  I've listed the paths
of the current links in cells E11:E47, and what I want the paths of the new
links to be in cells C11:C47. How can I change the code below so that it will
change all the links in the correct order for ...

I imported 20,000+ rows and 150+ columns from Filemaker Pro into Excel
and I would like to re-format it before transferring into Access.
Right now, all the data are into 1 worksheet but I would like to be
able to separate them by category into multiple worksheets. Because

I am copying text from a web page, then pasting it into an Excel file.  The
below code gets the job done using SENDKEYS and activesheet.paste.  However,
depending on the computer I'm using, activesheet.paste does not work ALL the
time (usually the first time it errors out, then ...

I have a number of cells that use Validation by List. When a user clicks a
button, these cells are copied and inserted below. How can I turn off
Validation by List for these newly inserted cells?
Thanks,

I have a workbook that i need to delete some cells automatically after
sorting. The rule is to use one specific column (say column O) as
reference, i.e. values<100 in this column, together with things in the
same rows should be deleted, basically it's to delete a range of data?

Guys,
I am having problems with Excel 2000 to Excel 2003 dll in production.
I am having version 2003 in my PC and I used the below code change to
open password protected excel files in my application. My application

i have a worksheet with several columns, and i want to use one
specific colume as my reference, i.e. values under 100 in this column
as well as values/texts in the same rows should be deleted, basically
it's to delete a range of data based on certail value, is there a

I have a toolbar that is created every time I open Excel and removed when I
exit Excel. I was hoping that someone could help me out with code for adding
the toolbar only if it's not already there (so that if I move it around it
will be in the same spot as the last time I used it) ...

Using Tools, Options, Calculation, I set Iterations to TRUE.  When my
user-defined function retrieves the value of Application.Iteration, it is
FALSE, even though I just set it to TRUE using the user interface.
Any idea why?

I want to be able to open a workbook that is currently open by another user
on a shared network by using a macro.  I then want the macro to automatically
select ok when prompted about being a read only and then to select update.  
Next, the macro should save the file as a ...

I need to create a report (worksheet) that is populated with references to
values that are missing in a "data sheet".  But rather than enter one row for
each missing value, if all of the cells from C1:M1 (just an example) are
empty, I want to do enter just a single row in my ...