I have recorded a macro in excel. The macro includes current date and current
time which are pasted into two separate cells.  I use ctrl+; and ctrl+: when
programming the macro.
When using the macro, the values of both date and time are constantly the

I am trying to do a very simple statement, but vb6 keeps giving me errors on
this line.
I want to search for the next available line (that is empty).
Here's my code, what have I done wrong? It is giving me the error on the

Merry Christmas and a Happy New Year.
I want to
#1. Identify controls in my userform1 as checkbox
#2.Find out how many and which checkboxes are checked

i need a macro that will automatically import text files (fixed width) from a
specific folder. the number and names of the files in the folder will vary at
any given time. i would also like the files to be imported to the same sheet
(there's not too much data per text file).

I really liked this example because it is extremly effecient when
hiding zero values in a given column, but I was wondering if I could
get some help in modifying this example for when the column is unknown
but has been selected.  The reason I ask is I would like to use this

using access 2007 and excel 2007, can't run a macro in excel from access
here is the error message: "The macro may not be available in this workbook
or all macros may be disabled."
the workbook that contains the macro is in a location that is trusted by

Via a textbox, the user enters the two columns to be graphed against each
other. In the 4th row of each column is the column name.  I need to extract
these column names to label the x and y axis of the graph.
Thanks so much!

I've been going around with this and can't find what is wrong.  All
replacements to 'Tablespg' occur as they should.  All changes to
'LineItemspg' do not.  I have double checked the columns involved  on
'LineItemspg' and they are correct.  The Debug.Prints return the correct

I have been working on this all day. My VB add in manager is empty. I have
read that this can be a problem with being signed on to the wrong user
account, but I am the only user on this computer and I have administrative
rights.

Using MS Excel 2003
I have 2 workbooks open in my Excel window.
Wb1 catches the exported data from QuickBooksPro (in doing this, QB
overwrites any data that is on a worksheet already, precluding my

I need to create a formula that will calculate a date 21 business days from a date entered into an adjacent cell.
Example:
In cell A a date would be entered say, 12/12/07,
Cell B would then insert a date that is 21 business days later, but also add 1 day to the nearest Friday. So ...

Is it possible and how do you format a sheet programmaticlly in VBA. I would
like to format a newly created sheet once the data is copied or when the data
is copied from another sheet. I would like to format the new sheets with
borders and header rows with bold names to match the ...

I am trying to search for specific text in a worksheet.  I need to do this
from a udf that is in an add-in, and the search does not return a value (rng
= Nothing).   If I copy the logic to a module in the workbook itself, it
works.  

Thanks,  but how would you format the field and use it in sqlstring ??
Dim a as String
Dim b as String
a = Range("A1").Select

Need some help I am currently using this macro -
Private Sub Worksheet_Change(ByVal Target As Range)
Dim LastRow As Long, ws As Worksheet
If Not Target.Address = "$A$1" Then Exit Sub