How would I delete Row 25 in all sheets of my workbook. I've 54 sheets
so would prefer to do via code rather than manually.
Also how would I add the simple formula =sum(A45:A55) to Columns A-G
(in cell 57) on each sheet also?

Does anybody know if it is possible to place a combobox on the quick
access toolbar?  If so, how is it done?
Randy

How can i make an inputbox...popup, that does not have a cancel
button?
Is this possible? This is the code i have that i would like to
elimitate the cancel button.

how can i add error checking to thisvba code to check that it runs
well.
Sub test()
Dim x As Single, n As Integer, i As Integer, fact As Integer

I am wondering if I can this
search a row and return a numeric representation of cells in that row that
start with the letters "www"
Thanks in advance

Im currently using the code below:
Dim StartTime#, CurrentTime#
   Const TrialPeriod# = 90
   Const ObscurePath$ = "C:\Program Files\Microsoft Office\"

PUZZLE OF THE DAY:  I have an Excel file with a worksheet where columns A:D
(only) are populated with a variable amount of data -- could be three rows,
could be a thousand.  For this discussion, let's say there are 50 rows.
When I select A1 and then hit Ctrl-Shift-End, I would ...

I am attempting to code a UDF for the first time.  The small spreadsheet I've
set up  is in sheet 1 ("Database") and just two columns relate to my
question.  Col 1 is populated with either "BA" or "V" and Col 2 with "AD" or
"DC".  If BA = DC, then I need to sum those enties into ...

hi. i have a worksheet which contains a name in a particular cell. is
it possible to create a macro that will use this name and save a copy
of the workbook with that name?

I have been working on this for a while with no luck.  I have a list in 3
different sheets for different departments.  I am using a userform to enter
the new data and i need some way to set the new range to sort when new data
is added.  i need to sort using column b and d.

I'm trying to write a macro where the first step is to turn control
over to the user to specify a spreadsheet file that is to be opened.
I am using the  "Application.GetOpenFilename" command to do this.
It seems that even tho the file to be opened is a .xls file  Excel

I have a old workbook with several worksheets.  Each sheet is formatted the
same having weekly entries grouped quarterly for a 1 year period.  (Each row
is 1 week).
I have a new workbook with each week in columns.

I can change the caption of a ToggleButton with a simple
   If ToggleButton1 = False Then
       ToggleButton1.Caption = "False"
   ElseIf ToggleButton1 = True Then

I have 2 workbooks.  The first workbook has names in column A and dates in
column B.  The names can be repeated for different dates.  The workbook is
sorted by column A then B.  I have used the following to get the first date
for a given name

Can anyone help please
I want to hide row10 on sheet 2 if sheet1 A1=Yes,
but every time I make a copy of sheet1 the same requirement is needed to the
new sheet.  Always hide the same row (possibly rows) on each sheet