I dug around but didn't find this issue (although likely basic).  I'm no VBA
programmer so step by step help would be appreciated.
I have a multi-sheet workbook.  "Summary", "Detail1", "Detail2".
In the summary sheet, I would like to have three buttons:

I have this string that is programatically inserted into a cell as an
array formula:
=1*MID(A2,MATCH(FALSE,ISERROR(1*MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)),
0),LEN(A2)-SUM(1*ISERROR(1*MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1))))

Gonna try to keep this simple...
I had a pivot table that when I created it, I kept it in a different
workbook from the data, but in the same folder. It worked fine when i
chose the refresh on open option.

is there a function i can use to append some character to a cell
Example:
cell contains   ABC
i am looking for something the can add a Y harcter either at the

I'm trying to load a value from my sheet into a textbox but multiplied by
100 so the percentage has the correct decimal place.  I am having trouble
getting it to work.
Me.txtRentalTax.Value = .Cells(Choice, 8).Value * 100

I'm an Access programmer, venturing into Excel VBA.
I have a form that contains a text value ("1.1.6") that is one of many
values in my TaskInfo Worksheet.  I want to use Vlookup to get the values in
the 2nd, 3rd, and 4th columns of this worksheet, but cannot seem to make it

I wanted to filter several columns for values that match a certain criteria.  
Then I thought a copy/paste routine would work better (there are too many
columns to use the filter tool). I found this simple cut/paste code on this
DG a while back and I tried to use it today and it ...

When I try to change the number of solver iterations I can't seem to
actually get it to do more than about 5.  I walked through the iterations
step-by-step and after about 5 iterations it quits.  If I start from that
solution a couple more times it gets to the solution, so I seem ...

Hi everyone.  I have a workbook with lots and lots of Vlookup formulas
that reference a data sheet inside a different workbook.  Periodically
I update the data sheet, and therefore thenumber of rows of data
changes.  Is there a way to have the Vlookups automatically know what

Hi Group,
Im trying to execute the following task:
i have workbook A thats made up of many sheets with 8 columns each. in
workbook B in need to run a search that looks in column 8(this column

I am trying to convert a word document to pdf in Excel. It converts
the word document into PDF if i manually change the default printer to
PDF printer, but when i try to assign the printer name using
ActivePrinter, it gives error: "Named Argument not found". Can anybody

Hi, everybody.
I'm trying to implement two macros associated with two respective buttons.
The first button ("Add Row") adds rows and copies the formulae and format
from the row immediately above.

I have a spreadsheet in which I log letters stating the results of
inquiries from various agencies. The inquiry status is either Found
("F") or Not Found ("N") in  the G column on the spreadsheet. Every
week, I log more letters, each new one added to the top of the list

I am trying to export multiple worksheets to .csv. This is what I have
so far:
For v = 1 To 7
Sheets(v).Select

I have an auto_open macro that unprotects a file, calls a sub to import a
.csv file, then the auto_open macro protects the file again. This should
never happen, but if the .csv file is missing, naturally there's an error,
and in this case the file is left unprotected.  I have ...