I have a worksheet 1 in a workbook A.  I have a code to move the worksheet 1
into a new workbook.  I want to name the new workbook using the two pieces of
data from cells A1 and C1 from Workbook A.  For example, cells A1 and C1 have
ABC and 123 in Workbook A, respective.  Then ...

I have a macro that I want to share with other users on my network. I went
through all of the steps to create an addin and it works fine on my system,
opens with every workbook, etc. but I can't figure out how to get it to work
on someone else's machine.

If anyone can guide me with the following, that would be great.  I
have the following code that opens up a new workbook, now i can't
figure out how to get some data from a query that was built in MS
access.  Any kind of sample would be greatly appreciated.

At one point within a macro I'm searching a column for a specific text
using the "Find" command.   If the search comes up empty I want to
display a message to the user and end the macro.   How do I do this?

I keep getting an error stating it can't create the top line. It errors at
the LineStyle Continuous.   I don't know why.  What do I need to check?
With Range("L2")
       .FormatConditions.Delete

OK, I am stuck.  I have this line of code that was working:
Doesn't work
lnglastrow = xlSheet.Cells(xlSheet.Rows.Count, "A").End(xlUp).Row
Does work

I am trying to find the row in which a string occurs but I just do not
understand how.
Can you complete this for me?
Sub zTest()

How to modify the column size without affecting the data in column.?

I am trying to build a custom function and could use some advice.  There is
more to it than this, but at the core what I am trying to do is a custom sum
function that lets you put any number of cell references in the formula.
This is a very simplified version, but if I can get ...

I have a worksheet where:
 Row 1 is the header row
 A2:Axx is UIC
 B2:Bxx is BLDG

I want to use the Datagrid or Flexgrid controls on an Excel user form.  When
I try to add the control I get a message 'The control could not be created
because it is not properly licensed' .  I am using excel 2k3 pro sp2.  Any
help with this would be appreciated.

I was testing VB code to modify the interface of VBA-programmed Excel
workbooks. Afterwards the two workbooks were shown in their folder and the
interface of one of the worksheets was displayed to the side, but when I
attempt to open either of the two books, Excel app opens but ...

I trying to implement Ron's code for merging multiple workbooks  (
http://www.rondebruin.nl/copy3.htm) , but the procedure fails to open the
workbooks.
Im getting Method 'Open' of object 'Workbooks' failed as an error.  The

I have created data validations sheet and want to protect from getting
spoiled through cut, paste, clear, etc. I have written following code but
disabling the "Clear - All" and "Clear - Formats" is not working. Can
somebody please help.

I'm currently creating a Physical Fitness Test roster for my work. I'm making
it to where as you fill in the information, it automatically puts the point
values into the corresponding cell.
I have three categories: Pullups, Crunches, 3-Mile Run. I have the Pullups