I use the code below to produce cummulative totals for a given month (Days
1-31)
Issue:
If i use this code to produce a row of data, for a mid-month report,

I am hitting debug 1004
"Unable to get th SpecialCells property of the Range class"
Any suggestions on what is causing this and how do I amend?
Thanks

I need a macro to delete part of a row eg. column H to Column M and in its
place copy data into these columns from the row directly below it. Once done
the row below should be "deleted". [please see below]
The Data is arranged as follows :

My code is not acting as expected and I would appreciate some help in
understanding why. (I know very little about VBA programming, so
answers in the most basic terms would be helpful.)
My task is to go through each unlocked cell on a worksheet and set the

Is there a tool that convert VBA code into XLL C API?

Please, I would appreciate help with this problem. I want Excel to suggest
the value of the previous row, each time the current cell is empty, but with
no need to define this with the classic native method (select, drag....).
Something like conditional format  that says:

I have a very simple piece of code (extract below), that copies the
contents from SheetA to SheetB, but I am getting a debug of "Copy
method of Range Class failed" on the line - Slection.Copy below
I can't see how my code could be any simpler and hence why the error

I have a work sheet code that changes the interior color of 32 cell
when double-clicked I would like to add to my existing code so that
the interior color can only in one column at a time for the active row
for example:

Hi! I have a workbook with multiple sheets using the same header. I'm trying
to insert the contents of a named cell from the first worksheet into the
header that is used for all of the other worksheets. The first sheet is
called Data Entry. The named cell is Target. The header ...

Is there a macro that will change the interior color of a cell on a
click or double click? And then change it back to the default if
clicked again. I want to be able to go back and forth.
Thanks

does anyone know how to determine the name of the pivot table the user
has selected.
I have code I want to run against the selected pivot table however the
name of the pivot table is not constant nor is it always the first

Dear Excel Gurus,
I have just encountered the strangest error. Is it a bug in Excel VBA
compiler?
Below statement encountered overflow error (run-time error 6);

I have a drop down list in E4 with the following options, Survival,
Operational, Transitional and Manual Entry.
Survival, Operational, & Transitional are tables with numerical values.
Should one of the tables be selected in E4 I would like a value from said

I have the following:
Dim vtInput() As Variant
totalrows = ActiveSheet.UsedRange.Rows.Count
vtInput = Range(Cells(1, 1), Cells(totalrows, 2))

I found many examples how to copy a sheet form one workbook to an other
in this newsgroup. But I want to copy a sheet (including all Data,
formating an formulas)  and paste in with a new name to the same
(active) workbook.