I have a macro which deletes row 6 from my worksheet.
eg "Rows("6:6").Select"
However I want to amend this code so that instead of deleting row 6  I want
to delete the row number equal to a counter value that I have defined.

I have a report that I import into Excel each day.  At the bottom of the
report is text I want to delete before running a macro.  The number of rows
in the report varies each day.  I'd like to add code in my macro that
automatically deletes that specific text at the end of the ...

I want to know if it's possible to do a floating menu?

I'm new to this forum, but somewhat familiar with VBA in MSAccess97.
What I am hoping to accomplish is to create a macro, to be run with a
button click that will perform the following functions:
1) Delete some unecessary columns from one spreadsheet that will always

I have had a lot of help on this project and i need just a bit more PLEASE!
I have a userform that has a listbox with multiple columns in it. I have it
set so the user can choose as many rows as they like. The data that fills the
listbox comes from a named range ("Database") from ...

In a listbox that allows multi selections and has multi columns when the user
makes his selections how do you place text such as "PAID" in column F for the
corresponding rows selected on the database worksheet. Note: this worksheet
is the same info filling the list box. Thank you ...

I have conditional format in C2
the condition is
c2 is grater than B2
I can find this out by selecting C2 and see

I asked this in the Access forum but no solution.
I am opening Excel from Access. Problem is many times a hidden session
remains in the windows task manager - processes.
I checked my code (all explicit declaration), send it to the Access forum,

Excel 2003.  FIRST, I want to just be able to print (to my default printer)
the contents of a text control on a user form.  I was given the following
code, but the printout is funky (margins are super narrow).
  Dim PrinterName As String, I As Integer

Excel 2003.  I programmatically build a year to date master workbook from the
monthly workbooks we create.  The master and the monthlys all have the same
number of sheets.  I simply copy sheet 1 of January, sheet 1 of February, and
so on into sheet 1 of the master, with each ...

I have this code:
Private Sub Commandbutton1_Click()
 With ActiveSheet
   Select Case UCase(.Range("c1").Value)

Hi to AP and All,
The procedure below adds a thick border to the bottom of my varaible
array.  I want to replace the fixed range "Range("C13:M14").Select"
with the

Ok, so I inserted a macro that specifically formatted my printout of a range
of cells.  I decided to change that formatting and deleted some lines of
code.  HOWEVER, when I run the macro, it prints out the range of cells the
original way the code was written.

I think my question is too simple, because I've been searching through
these threads and can't seem to find the answer.  All I want to do is
write into my macro the code to delete rows 1 and 2.  That's it.  Can
someone tell me what code to use?  I'm afraid I'm a little too new at

   If Range("h9").Value = "N" Then
   Selection.AutoFilter Field:=1, Criteria1:="+"
   End If
I want to be able to replace "h9" with a variable that i can change