I have the following code to find the max value in range E of a
worksheet.
Option Explicit
Sub findmax()

i have a worksheet for my flexi timesheet. it automatically populates the
dates for a month in collumn A based on the following formula:
=IF(MONTH($A$18)=MONTH($A$18+ROW()-18),$A$18+ROW()-18,"")
i want it to enter my usual hours in collumn N. but i want it to enter 0:00

I'm using excel 2007 and 2003. I have a routine to loop trough *.txt
files in a folder and search for string in a single line. All was fine
until I had to, based on found value, take all lines from this value
to top, e.g. When I find a line marked with specyfic marker ("in this

I inherit a XLS file that has multiple pivottables, and no underlying data. I
have to refresh each of these tables one at a time. (yuck) is there an option
I am missing? What VBA could I use to make this easier for me?

I am brand new to Macro writing and I' m currently stumped!  Trying to
write a Macro that I can use anywhere in a workbook on new or exisitng
sheets.
Attempting to copy a series of formulas (2 rows 25 columns across-

I have two questions that hopefully someone might have answers to.
First, i have created a plug in for excel that i use only when a specific
file is opened. The plug in also creates a toolbar to run this code. Is it
possible to only show the toolbar when that specific file is ...

Hi,
I am new to creating macros in Excel.
Can someone please help me add to a macro I currently use.
All I want to do is search an excel workbook for a particular

I am getting an error
Object does not support this property or method
Here is the code i am trying to use
Private Sub cmdDelete_Click()

I am trying to set these as public constants so I don't have them retyped
all over the place.  I use the same form and reset the RowSource depending on
what I'm doing.  So, I wanted to set them in one place and use them as a
variable.  This is what I tried

I am trying to create a VB function with a nested if statement.  I
know how to do this in Excel but I have 16 different options I need to
choose from and Excel of course limits you at 7.  Here is the code I
have written so far.  The d10, l10 etc are the cell numbers in excel.

I have a two spreadsheets in the same workbook named:
LAWSON
column a: EEID column b: LASTNAME column c: FIRSTNAME
Bi-Lingual Skills

We work primarily with Julian dates.   I have an Access data query that
converts the Julian to Gregorian date using a function I built called
"Convert_Julian".   I now need to create charts from the data but when I set
up the Data->Import External Data->New Database Query and ...

what if I need to count number of days except if cell d17 is not the end of
the month. Example C17 and D17 are as follows:
c17=11/25/07   d17=11/29/07 instead of it returning 5 days I would need it
to return 4 days because the client was not here until the end of the month.

I have a requirement, however after some help on how I should be
looking to approach this or if anyone knows of any examples that
already do this on the web.
I need to check roles within our systems to ensure there's no SoD

CSV/My text file has data in it which originates from a spreadsheeet.  My
goal is count the number of columns of data which were pulled into the text
file.  In a simple world I would just count the fields at the top of the text
file.  But I have no control over the imported data ...