It's returning a r/t 1004 - The extracted range has a missing or illegal
field name
message << maybe just under certaini conditions,,>> my current problem (when
I'm getting the error message occurs when --

I have a VBA form that I'm using in Excel 2002. On one label in the form, I
want to run one function from the click event and another from the
double-click event. However, when I double-click the label, I always get the
click event. I've checked the double-click speed from ...

I am trying to pass a custom class through a function, I can watch th
variable, it gets passed to the function but when it goes to b
returned I get this error,
*Object doesn't support this property or method (Erro

This should be easy but somehow it just escapes me how to do this.  I need to
extract a birthdate from a text string.  For example, the text string
12VEC1461001 parses left to right into 12= month, VEC = not required, 14 =
day, 61= year, 001 = not required.

I desperately need to convert a report I receive every month into a
pivot table format.
Here is the table:
Country       Jan    Feb    Mar    Apr    May    June   .....     Dec

Hi there. I've got some code that does various things, among them,
opening an Excel file. Here's a little snippet of relevant code:
          FilePath = "\\servername\share\folder\"
          FileName = "template.xls"

I have a worksheet which has 2 cells unprotected to accept a date and a
clientID respectively. I also have a commandbutton with a macro behind it to
take the two cell values and pass them to a SQL query which returns results
to another section of the worksheet.

I am encountering a very strange behaviour. Last week it was taking
almost 2 sec to unhide/show 10,000 rows. But, today it is taking almost
3mins to show the same rows.I opened a last week version of the
workbook and it took 2 secs to show the rows.

I have a large Workbook with a hyperlink to a spreadsheet (same workbook)
with history on it. When you click the hyperlink it takes you to that sheet
R1,C1. In that sheet R1,C1 I would like to return to the cell from the
previous link. example I click on R55,C1 on the master ...

I need to create a macro that will be able to determine the total
amount of time from 8:30am till 4:30pm between two columns (column A
holds the start time and column B holds the close time) and have it
insert into column C the total amount of time calculated between two

Dear Friends,
I'm using a formula in excel and want to convert the formula into values, so
that it won't change further. Let me explain it.
The thing is that, I want to enter the current date if the user enters "Yes"

I have a couple of userforms/workbooks that I need to save to a closed
workbook... How can this be accomplished... I have searched but to no
avail.... PLZ HELP...

Good Morning,
I have a routine for inserting a copy of another column. The sheet wil
eventually need to be protected before others in my office can use it
so what I would like to do is to create a delete command button "tied

Hello, I am working on one of my first pivot tables and need help getting a
calculation of % a row subtotal in a column instead of % of grand total.
We have over 300 stores using a cumulative total of over 400 vendors and
would like to get a column of the total $ purchsed through ...

Firstly can I just agree with Pianoman that this is definately the best
forum I have come across and always get an answer. Very satisfied with
the level of compassion and helpfulness here!
Anyway, I posted the other day about this timetracker im trying to