when put in a command button all unqualified references like

Range("G3").Select

are interpreted to refer to the sheet with the command button. Your intent
is to select on Master Inventory, so that is your problem. Master Inventory
is the active sheet but the code says to select on the sheet with the code -
but you can not select on the sheet with the code because it is not the
activesheet. If you want to use your code as written, move it to a general
module and call it from the CommandButton click event. In a general module
it will work as you expect it to. Otherwise, you would need to fully qualify
all range references to include the sheet.

--
Regards,
Tom Ogilvy

"brwilson" wrote in message
...

Below is the code I am trying to exicute.

Range(Cells(6, ActiveCell.Column), Cells(325,
ActiveCell.Column)).Select
Selection.Copy
Sheets("Master Inventory").Activate
Range("G3").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlSubtract,
SkipBlanks _
:=False, Transpose:=False
Range("O1").Select
Sheets("Sales History").Select
Range("H3").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlAdd,
SkipBlanks:= _
False, Transpose:=False
Range("A3").Select
Sheets("Trucks").Select
Range("A9").Select
Application.CutCopyMode = False

I get error message indicating a problem with "range("g3").select

any suggestions?

Thanks


---
~~ Message posted from http://www.ExcelForum.com/