just wondering if anyone has seen this
this happens in all cases, but here is an example:
i loop through about a dozen workbooks, opening, copying some data to a
report workbook, and closing it.

I have the following snippet of code (thanks to someone here)
Public SummaryMin As Date
Public SummaryMax As Date
Public SummaryDate As Date

I have Public Sub Unlockbuttons() Macro recorded in a module.
How do I execute this macro from within code in a userform.  I'm using
this code:
If Sheet6.Range("f49") = 0 And Sheet6.Range("f59").Text =

I am using the below routine, which I found in this newsgroup, but
instead of saving the file as Postingsum011706.iif, it renames the
current sheet, I don't want to change the worksheet name, I want to
change the file name for Postingsum plus date, which is located in

I have a list of file names with their full name (ie Path + Name) in column
A.  50 files total.  Is there a macro or funtion that I can return the last
saved date for each file in column B and the time it was saved in column C?
Thank you for your help.

LEITH, KEN, thank you very much for your help to me, on ActiveCel
Address in macros.
Bless you.
AC

I want to delete a sheet from workbook without any instructions o
message box. When i try to delete the sheet it ask
"Data may exist in the sheet(s) seletion for deletion. To permanentel
delete the data, press delete."

When a linear trendline is added to a chart, the linear equation which best
fits the data can be displayed.  It takes the traditional form of y=mx+b.  Is
there any way to programatically capture the values of "m" and "b"?

I have a Userform which has a one Multipage with a spreadsheet and one Frame
with two Textboxes. At the moment I have a value which is displays on the
spreadsheet (say A1) and the same value also displayed on one of the Textbox.
But when I close the programme down, it does not ...

I'm running Excel 2003 in Windows XP.  I have 256MB Ram on my PC.  I needed
to create a 1 dimensional array using VBA macro programming with more than
32768 array elements.  When I try to read more than 32768 data points I get
an overflow error.  I'm very surprised about this ...

I need to generate a sequential number list, but I need it to skip every
13th number. I am starting with # 2343

I'm fairly new at this and could really use some assistance with an Athletic
Score Sheet.  Here's the situation, simplified:
Worksheet1 has columns as shown.  Column X's values are based on a formula,
not just values.

How can i do that by VBA? I just want to get the print dialog of the sheet2...
seems easy but i can't figure it out
bye

I have a file that is used by another person in their directory.  When they
save the file I do various tests on values of certain range named cells and
if all the values are ok then that means the file is basically in good order
and I want a copy.  The issue is they sometimes ...

Hey Everyone,
I will use one row as an example, however, there is a huge range I'm dealig
with.
VBA UserForm Question-