I have a sheet that runs a query on our ERP system.  A second sheet is a
pivot table based on the returned data and a third sheet contains a graph
with buttons.  Depending on which button is pressed, relevant data for that
department is returned.  This is for yield analysis so I ...

Okay, here's a new one for everyone...
I want a macro (that I can assign to a button) that will allow the
user to select a cell and will delete that same cell from certain
other sheets.

I found this bit of code on the internet.
Copy all the rows that have the value 1000 in column D and paste to
Sheet2:
Find_Range(1000, Columns("D"), xlFormulas, xlWhole).EntireRow.Copy

in my excel workbook project I use a lot of VBA code where I open different
external data sources, hide and unhide some worksheets and do things that
shoul not be explicitly viewed by normal users. So I protected Visual Basic
code with a password what is probably not the best ...

I have found a problem while accessing Excel spreadsheets via OleDB (I'm not
sure if this is the correct newsgroup for this, but here goes...)
The problem only occurs if I have used filtering in the spreadsheet. Could
anyone tell me if this is a bug? Is there a workaround?

When the active cell is B1, I want the curser to move to cell H17 when  press
enter.  I need the VB code to do this (or a macro)

If my data is something like this;
A              B                              C
Sharp    ND-208U2                   208 W
Sharp    ND-216U2                   216 W

I have file .xlsx with password. If I rename file to .xls and try to open
this file, Excel 2007 ask me password and then it is generated prompt Window
with message like "Actual format of document is different from format given
by extension. Open this file?" So, can I prevent this ...

I want to pass a floating-point number to a VBA function and access
the binary representation.  In C, I might declare a union of double
and 8-element unsigned char array, assign the function parameter to
the double, then access the bits of the unsigned char array.

I have a form that I want to control the return value coming from a code and
when I use: UserForm1.cargo.Value = AnswerCell.Offset(0, 2).Value , Im
getting an error 91 Object Variable or With block var not set.
Any thoughts?

I use an autofilter on my 'database sheet' of records to selectively filter
the required data.
I currently scan the visible filtered list and transfer data to my report
and chart sheets.  I scan from the first row to the last filtered and

I would like to something using macro but really I don't know how. This is
something I like to do
In a data containing worksheet,
1- finding the last cell which has value or text in A1 column in worksheet-A

I have an add in that i have installed with all my macros in it. In one of my
macros i call it to open another workbook for a vlookup. i then want to
continue with the previous workbook but i dont know how to return the focus
to that workbook.

I'm very rusty in Basic and have no Visual Basic experience! I want to use a
function to reset a stop loss target if needed. The spreadsheet has a cell
with “Day’s High” as a dollar value, “Old Stop Loss” also as a dollar value
and I will pass in a float with a stop loss percent ...

I have a simple question. I have a worksheet that has a list of item
to be purchased that is referenced from another sheet.  =Sheet1!E10
What i want to do is keep the link but add text after the formula.
My end result should be =Sheet1!E10 & " add some kind of note"