I have the logic in a macro to turn off the scroll lock button,  but now I'm
wondering what the macro type should be.
Do I need it in two places - one at the workbook level to make sure that it
is turn off once the workbook is loaded and another at the workbook change

I have a worksheet that loads automatically (Xlstart folder), but hidden.
There is a few macros in it, but what I want to acheive is when I open a
file I want a macro to execute, but I don't know where to put it.
It doesn't work on the workbook_open sub, since this one starts only ...

Hi everybody,
I am working on a macro to help automate some of the tasks being done to a
group of spreadsheets that are updated often. I can email a dummy workbook to
illustrate what I am talking about if necessary, just let me know.

I have a user form with a list box that I would like to show the unique
records from one column in a worksheet.
I've thought about several ways to do this but was wondering if there is a
really easy way using arrays.  The unique records would only need to be

Is thier anyway to have VBA evaluate a column in order and if a cell
is null to enter the value of the cell above it?
As well as stop at a certain row?
Thanks,

I am recreating a toolbar that I'll use when I'm writing code. I
created it a long time ago, but I was given a new computer at work on
very short notice (15 min) and a lot of this kind of stuff got lost in
the transition. I tried to name it "Macro", but XL says it already

I am looking for a way to count the number of Red Cells on a worksheet and
return that number is a message box.  Thanks in advance!

I am placing information to a worksheet via vba code and the wrap is not
working.  How do I correct this?  Here is my code:
Sub SaveTenantName(Choice)
   With MainPagepg

I do a lot of downloads with CSV files that I pull into Excel and then
have to format, so I wrote a macro that does 99% of the formatting I
need to do, but I'm having the darndest time getting a macro to select
the whole range that has values in it starting at Cell A1 and going to

This function returns the last row number of pxRange :
int WINAPI LASTROW(LPXLOPER12 pxRange)
{
  return pxRange->val.sref.ref.rwLast;

 What is the best way to programmatically install XLL add-ins? It looks
like Excel stores the list of enabled add-ins in the Windows registry (key:
HKCU/Software/Microsoft/Office/$version/Excel/Options, values: OPEN, OPEN1,
OPEN2 etc.). Should the installer just add another ...

I am starting to play with macro features in Excel.  For testing purposes, I
have created a table of random values and want to creat a macro that will
plot a line chart of selected values.   I've encountered an error and am
asking if someone can explain why it is happening and ...

I'm trying to write a macro that will take the text in a cell (ex. B10) in
worksheet A then go to worksheet B and search Column C to find a match. Then
I'd like it to copy the match and the two cell to it's left from worksheet B
and past that back in worksheet A in cell C10. I'd ...

I currently have a program that compares names in row 1 with another
spreadsheet and deletes the columns if the names aren't there.  This was easy
as there was only 1 column under a name.
Now there is another column that I do not want at all.  So I need it to

Is it possible to make a cell mandatory- without a macro and not allow
the workbook to be saved or emailed as attachment.
Thanks for any help
Shanu