THIS MONTH has a command button named "btnProcessData"
After the copy, the new sheet that has been renamed to the text string
stored in sWksName still has the button named exactly the same (verified with
a For Each loop displaying the names of all shapes on the new sheet)

I'm using a column of data in a VLOOKUP search.  Unfortunately the actual
data can have asterisks at the end, e.g.
MyDataColumn
EBV-1003

I have the following code that allows users to pick multiple choices from a
data validation list.  The problem with the code is that users can pick
multiple choices from all the lists in the worksheet and not just F, J, V, O.
How can I change this to only allow users to choose ...

I'm using excel 2007.  We have a schedule that we have to follow to call
overtime in.  Is there a way to create a button that when clicked would
search the columns for blank cells, then sort first by the column that it
finds a blank cell in, and then sort by another column that ...

When i click cancel it comes up with an error "Run time error'13', type
mismatch"
Here is my code so far
Private Sub Worksheet_Activate()

ActiveWorkbook.Sheets("Sheet1").Cells(i, 3).Value = _
           ActiveWorkbook.Sheets("Sheet1").Cells(i, 1) / _
           Application.SumIf(ActiveWorkbook.Sheets("Sheet1").Columns(2), _
           "<>XXX", ActiveWorkbook.Sheets("Sheet1").Columns(1))

I want to take data that users input into a User form into the spread sheet.
I currently have 4 text boxes that are called:
TextBox1
TextBox2

I've built some code to pull in data from Workbooks submitted by my
stores.  These workbooks have been in use for some time and several
'versions' have been released, with some format differences (ie data
in different cells).  For this reason, it's important that workbooks

I'm getting a type mismatch error, at the point of 'For Each pic In
wsSource.Pictures' in the following code - any ideas why this might be?
=============
Sub CopyAllPictures()

Could anyone help me here please,
VBA (I'm using Office 2003) will find a specific Cell in a spreadsheet in
Column C, and I then want to Change the Selection to the Same row in Column E.
Any ideas are welcome, Many thanks!

i hope i can explain this better than i did before. after reading my old post
i can see i was not clear at all. what i am trying to do is take this group
of numbers below and make groups not exceeding 168.
main group

I've searched thru lots of posts, and I can't understand why only I seem to
have an issue with starting a macro based on a cell change. This code:
Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.Address = "B3" Then

Hi. I am new to the VBA idea and am trying to learn. My Functions work fine,
but am I putting too much extra in that is not needed?
I have a sheet with C5 the contract term, C9 the total gross salary based on
contract term. Follows is my code to work out Employer NI, Tax, and ...

I am trying to create micro with requirements as below -
1. cell(2,3) gets focus and if cell(2,1) and cell(2,2) are blank, macro
should put 1 in both.
2. Cell of Any other row (2 onwards) in column 3 gets foucs, cell(row,1)

I have a code that refresh data. Sometime's no data is retrived and
code stops.
What is best way to handel this error. I have following but am sure
there must be a better way to do it as have a lot of error handeling