Hi everybody!
I´m looking for an excel wizzard that can help me out with (i guess) a bit
of programming.
What I am looking for is the ability to RELATIVELY easily send out

I would like to runa macro that creats a chart, then show the chart in a form.
Can that be done?

I have a range: A1:E10.  Every cell in this range has a formula in it that
looks in other sheets and makes calculations.  If the cell value is 0 it
leaves the cell blank.
I want to find the last cell (bottom right) in this range that does not

Hi, I have two macros set  on two buttons in my spreadsheet. One macro
add entire row and one macro delete entire row. I want macro in my
Sheet Module that if I cross deleting rows by deleting row macro from
Row 20 in sheet then Message should come up saying that "YOU CANT

I've got the following vb code in an Excel macro to unprotect all worksheets
in a document:
Sub UnprotectAllSheets()
Application.ScreenUpdating = False

I have a table and say I would like to create a unique list from
column2 and store the list in a spearate sheet. Give this unique list
a name.
Use this unique list in a FOR EACH loop and apply autofilter to two

hey...
fyi...
at the moment i got 2 sheets that has a row (B23:T23) where the user needs
to enter closing stock.  (a couple of colums are blank(future use)Sheet2

I am relatively new to macro writing.  I have written a macro that copies 30
lines of a spreadsheet ( this is a template for student report ) 300 times
into the rows below it.  Works fine at first, quite fast as one wouls expect.
However, as more sections of the 30 lines are ...

Hello.  I have a button that copies an existing worksheet and names it
"New Csutomer".  The problem is when the user pushes the button twice
the code errors out because there is already a sheet named "New
Customer".  Is there a way to append a number to the new sheets so

Hi all, i would like to find the latest file in a folder and open it with
code. The files would have different names as they are updates with a code on
the end. Could somebody help me with this please.

I can disable "New" and "Open" menu items in Excel 2003 by capturing those
events - but it's not working in 2007. How can we disable menu items in Excel
2007 programatically? Thanks for any help!!

Not sure if this is the correct group or not.
I need to massage an Excel spreadsheet.
Specifically, if a cell in a column contains
more than one element (separated by commas)

I query a web page multiple times in a loop with a parameter to get different
pages. QueryTable does not get all the info I like.   Furthermore, it does
not work unless one put in a delay in order for excel to wait for the result.
Found the OPEN method in a book; Workbooks ...

Windows XP Pro SP2
Excel 2002 SP3
Seems that cells that are conditionally formatted don't return an expected
Interior.ColorIndex value.

I currently update one of my programs by using the external data option on
the Data Tab of the ribbon.  There are 6 different websites that I query at
concurrent times.
What I need to do is control some sites from being downloaded at certain