I have this code and keep getting the error, ..I have notated where
the error hits, can someone help me out?  Basically, when a value is
selected from a dropdown on a sheet, values are filled in to assigned
cells based on the dropdown selection.

Is it possible to find out if a selected shape is just a line or a shape
(i.e. has a line color and fill color)
Thanks!

there are over 100 controls on a userform and they are misrodered, I have
changed some TabIndex by hand, but they are reassigned while I assigned new
value to other control's TabIndex. How could I do it in a simple way?
Clara

I have created an Excel workbook that uses user forms for data entry.  This
workbook is available online via our intranet and several users are
reporting that they are getting a "Complie error in hidden module:
<userform>".  I've read the other forums related to the moving of the ...

How can I set a default value for a control such as textbox just using  its
property.Could Control Source help here?
Clara

I am creating a macro that will use data that resides in the same
directory as the file that has the macro code.
My Macro runs like this:
   Workbooks.Open "Slash Daily Case Closed.xls"

Here's what I've hacked together that doesn't work:
Sub TryNow()
Dim myCount As Integer
Dim StartRow As Integer

I have a simple problem that is perplexing me. For some reason, when I
Copy and try to Paste Special between two different workbooks, It only
reads my copy as a picture and will only let me copy it as an image or
an object. I was doing this before with no problem. I would Ctrl - A

Jsut wondering whether theres a worksheet function or code that could
automatically insert a row for every 20,000 row?  or just every X
row??
Thanks for your help :D

I was expecting myCell.Row to return the current Row number as an integer
when I loop through a series of rows in a Range. It appears to think that "1"
is all I will ever need to know <g>!
What is the correct way to ask for the current Row number?

...class"...
I am an Access Programmer who was asked to do conditional formatting for
more than 3 colors.  I got code from Google that I modified to the code
below...it has worked well for maybe 2 years until Friday...See..."' THIS is

I have a userform that uses the filesearch command to get 132 filenames from
a subdirectory and put them into a listbox that I pick the filenames from.  
The filesearch command is way too slow --- taking 30 seconds every time ---
so I'm looking for a more efficient way.  Any ...

Hiya,
I'm creating an excel model for use by a team of staff in my office.
I've included the weekday function for one part of the model to calculate
days where we shift to/from daylight savings.

I have a very strange problem, I've never seen before.  I have one
workbook, two sheets.  sheet1 contains 130 employee id and name.
sheet2 has 1500 employee id numbers, with address, city, state,
zip...etc.

I am trying to run a PIvot table macro and when I run it, I get Error
1004. However, whenever I run the same macro step by step(using F8),
it works fine . Here is the macro code..
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _