I am trying to use the OFFSET($A$1, 1, 2) command. What I want to do
is to make the row count up 1-20 as I go down my column, but I need it
to do that about 20 times, repeating that block. I have tried to get
it to repeat, but I cannot.

I have the following BeforePrint routine in my ThisWorkbook module which
places a custom header on pages based on the value of cells in the sheet.  It
worked except now if the value of the cell changes, it is not picking up the
change and stays with the old value in the header.   ...

I have a situation where I wish to call a file and I don't think
ShellExecute is going to work.
Specifically, the file I want to call usually opens with Wordpad of
Notepad, but it is actually a set of scripts that are run by a

I have an automation add-in which works fine on my UK English configuration.
If I change the regional language settings in the control panel to Danish the
UDF fails and returns #VALUE!.
I have simplified this problem down to the point where the UDF is simply

I want a VBA procedure to create a Worksheet_change procedure for each sheet
in a workbook.
I have tried many things, but each time Excel and VBA are shut down.
One Works fine:

I select a range in a row and begin formatting per the code below, I am
having trouble getting this code to work.
It will find the first cell with "TRG" but none of the others?  It appears
to complete the Font changes but not the alignment changes (less the first

I have a VBA code to apply values from a UserForm to a Worksheet.  My code
inserts the Label Control Captino into the Cell.  How can I force the cell to
have an accounting format.
Private Sub cmbApplyTax_Click()

I've developed a VB 6.0 program to import a fixed length fileds, ascii, text
file into a new Excel workbook.
I programmatically design a recordset and import the text file into the
recordset using these kinds of statements:

I have a spreadsheet with codes, number codes not programming, that need to
be pulled to a summary table.  I was wondering if there was a way of pulling
these codes automatically without including duplicates.  I would prefer if
this could be done through formulas instead of ...

Hi
How do I set the default value for an input box to the value in F13 on
"mysheet"
Thanks

I'd like to write a vba function, referencable by an argument of a vba
subroutine.
I think, the answer is NO, but i'd like to be sure about it.
I may avoid it, but it would be nice.

How do I write a procedure that selects a checkbox within a range of cells so
that I can change the cell that it is linked to and also change the name?  
Thanks

I totally screwed up...I posted this in the Access group.  Anyway, I usually
find what I need but not this time...
I would like to run a macro based on a column.  Example, if A7:A500>0, then
copy F7:F500.  Basically, if A7 is >0, I would like F7 to be copied and paste

How can i set up a formula to payout $100 for each unit an actual # is above
budget.
For example, if actual sales was 52 and budget was 50 then the cell should
read $200. 54 to 50, then it should read 400 and so on.

For what kind of computer was Excel created?