Hi guys,
I have an excel spreadsheet with a load of columns with various bits of data
in them. Basically i am struggling to get the VB code together which will
find specific entries in a specific column and then remove the relevant row

Would someone please be so kind as to compare and contrast the differences
between a sub and a function.  Thank you.

I have written a series of spreadsheets with cell logic for tax purposes, for
here in australia we have a system of GST tax which is insane. Anyway, I have
cell logic which works, then all of a sudden, I open the template file (saved
as a read-only file) and when I fill it out, I ...

I have a query on the overlap sunday for last week of sunday/weekend
and first week sunday/weekend.
For example, 30th June 2007 is considered last week of sunday/weekend
and I have tasks: XYZ that need to exceute it. But on 1st July 2007,

I am keen in having a pop up window display on opening an excel file, which
summarizes the contents. This window can be closed by clicking mouse anywhere
on the window itself. I know how to apply this concept in MS Access but not
in Excel. Can anyone please suggest a solution to ...

I have designed a template for staff to use when they have entered the
data and close the workbook a copy is saved to a specified folder with
a name that has been pulled from specified cells. The code is as
follows:

I've spent a couple of hours trawling the groups for an answer, so apologies
if it's there and I missed it.
I have an employee number in column b in a file named test, I want to lookup
the employee number in a file called nominal (column b) and return the

Here is what I am trying to accomplish.
I want one controlling cell in my spreadsheet where I manually write a
number from 1 to 10.
The spreadsheet has 10 rows with data for 10 variables for different dates

I have a macro that formats column data and imports it into an access
database. The data is scanned in with a barcode scanner. The problem is i
have to hit enter in between each item. All items are the same length. I
would like to see if i can format the data in a row to a column ...

I have one excel sheet, on sheet1 and sheet2 as following...
sheet1 has 1200 records
ColumnA  ColumnB  ColumnC
123              xxxx      YYY

I need help to find the first blank row in column A and need to select
that cell.  Any help would be highly appreciated.  
AB

I have a sheet called "CSV" in Workbook A.  Basically, I want to move that
worksheet "CSV" into a new workbook and turn everything into value.  Then I
want to save the new workbook as a CSV file and to name it as "Test.csv".  At
the end, I want the Test.csv to close.

I have a folder that has more than 400 excel files, and all of them contain
unformatted data. I have a macro for formatting this data that runs as
required. The problem is I need to open each file individually and run the
macro to format the data in each file.

I need to recalculate a worksheet many times using VBA to record the input &
output values from the model in the worksheet.  I need to detect when a
recalculation is finished before initiating the next one.  I tried using
    If Application.CalculationState = 2 Then ...  and

I have a row with a series of merged cells in it, (b43:m43, makes up the
merged cell). I need to autofit text in that merged cell. Every time I use
AutoFit it shrinks the entire row to one line (12.50). How do I get it to
autofit based on what is in the merged cells b43:m43? This ...