Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What's wrong with this picture
Ok this doesn't work unless the producedata is active. WHY? Just when I
thought I was getting this! Sub UpdateInvoiceList() With Worksheets("ProduceData") ..Range("Invoice").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _ "q2"), Unique:=True ..Range("InvoiceList").Sort Key1:=Sheets("ProduceData").Range("q3") End With End Sub -- Though daily learning, I LOVE EXCEL! Jennifer |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What's wrong with this picture
"Jennifer" wrote in message
... Ok this doesn't work unless the producedata is active. WHY? Just when I thought I was getting this! Sub UpdateInvoiceList() With Worksheets("ProduceData") .Range("Invoice").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _ "q2"), Unique:=True .Range("InvoiceList").Sort Key1:=Sheets("ProduceData").Range("q3") End With End Sub Hi Jennifer, You have an unqualified Range method call in the CopyToRange argument of the AdvancedFilter method. If Range("q2") refers to a cell located on the ProduceData worksheet, simply placing a dot in front of Range("q2") will solve the problem. -- Rob Bovey, Excel MVP Application Professionals http://www.appspro.com/ * Take your Excel development skills to the next level. * Professional Excel Development http://www.appspro.com/Books/Books.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connect a number to a picture bank and import that picture to exce | Excel Discussion (Misc queries) | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
What's wrong with this picture? VBA Date code.. | Excel Programming |