Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AdvancedFilter with VBA
Hello, I cant seem to understand this one line of code: myLocalSheet.Range(sheetName).AdvancedFilter Action:=xlFilterCopy, criteriaRange:=defPage.Range("QTY_Filter"), CopyToRange:=myLocalSheet.Range("A10000"), Unique:=False Specifically, the highlighted part, the thing is defPage.Range("QTY_Filter") is not one cell, its 3x2 matrix with stuff in it. and some of it is text !!!! some is empty tooo !!!!! and the 2 two rows that do have #'s have =1 So, how does THAT work ?? -- newToExcel ------------------------------------------------------------------------ newToExcel's Profile: http://www.excelforum.com/member.php...o&userid=27192 View this thread: http://www.excelforum.com/showthread...hreadid=471593 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AdvancedFilter with VBA
k. i have made a lil bit of progress since the last time i posted. the criteria basically copies all the "non-zero" columns so for e.g. product | qty | ------------------ prod A | - | prod B | 1 | prod C | 5 | after that line of code runs, ONLY prod B and prod C will be copied cause the qty column is =1. I still dont understand how a 3x2 matrix can do that. i'm attaching a snap shot of the range called "QTY_Filter". Somebody help..... +-------------------------------------------------------------------+ |Filename: qty_filter.JPG | |Download: http://www.excelforum.com/attachment.php?postid=3858 | +-------------------------------------------------------------------+ -- newToExcel ------------------------------------------------------------------------ newToExcel's Profile: http://www.excelforum.com/member.php...o&userid=27192 View this thread: http://www.excelforum.com/showthread...hreadid=471593 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AdvancedFilter with VBA
no replies !!!! :( -- newToExcel ------------------------------------------------------------------------ newToExcel's Profile: http://www.excelforum.com/member.php...o&userid=27192 View this thread: http://www.excelforum.com/showthread...hreadid=471593 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run Time error using AdvancedFilter | Excel Discussion (Misc queries) | |||
AdvancedFilter in VB | Excel Programming | |||
AdvancedFilter to Array | Excel Programming | |||
Help with AdvancedFilter method | Excel Programming | |||
AdvancedFilter question | Excel Programming |