I have been using Excel VBA to open a CSV file, find the last row, and copy
data to an excel file.  Once in the excel file using the .offset, I assign
the cell values to a variable.  Now that I have populated variables, I do an
insert query against a SQL table.  This works fine, ...

I'm sure this is a very simple question but it's still beyond me - so
I'd be grateful for any help anyne can offer.
I have an Excel spreadsheet with several thousand records of computer
parts. Each record has a unique identifier of 5 or 6 alphanumeric

In Excel 97 there was no inbuilt way to refer to the address of a function.
Kaplan and Getz put togeether a workaround for this (
http://www.trigeminal.com/lang/1033/codes.asp?ItemID=19#19) which is very
useful when required.

when using autofilter, i select a value i don't want, the autfilter gives me
all the rows i don't want to see. i hide them.
how do i see just the rows i haven't hidden?
don't necessarily need code, just how is this done?

Greetings!   Not understanding what I'm seeing.  I'm creating an Excel
workbook from MS Project VBA, then formatting a worksheet in it and
exporting data to it.  I want to freeze the pane, and captured the steps
below in a macro from within Excel, then inserted it into the Project ...

I am trying to populate cells from multiple CSV files into one XLS file and
I need to locate the last cell with data in column B and move the cursor to
the next row down in column A.  Can someone tell me how to locate that last
data cell ???

Please help!  I want to write a macro so that whenever I paste some
information in worksheet A, it will direct me to worksheet B.
Is there any way to do this in excel?
Thanks,

I received a workbook today to edit and it contains a situation I do not
understand.  It has what appears to be a simple Autofilter macro, but when
initiated, it does something besides what it appears to be meant to do.  The
code is in English, "mostly", but the comments are in what ...

How to use workbook is a database.
and each worksheet in the workbook is a data table in this manner.
So that i can use SQL statement to write.

Hello.
I've got a workbook in Excel 2003 that, for the most part, needs to be
read-only (if users save a copy of it, that's fine - I just don't want them
screwing up the "master" version).

I would appreciate your advice; I have a spreadsheet in Excel, which I'm
trying to make as easy as possible for users (seriously).
I have three columns and in two of the columns I have a drop down list, how
can I get the third column to come up with the answer, however columns one ...

Is it possible to use non-contiguous ranges with the vba code for advanced
filters?
I can not get the example code to work.
Example of code:

Hi there, I'm looking for the best way to create a userform that asks for an
Username and Password. I want to be able to add/remove a user, I know how to
do this by writing the info to a worksheet, I also know how to write the
info to a *.txt file... is it possible to write the ...

is there any difference between the 2? i can see where both could be used to
return the desired result.

Could you check my post named Sorting Worksheets Numerically please