Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter Macro with Cell reference
Hi there, I'm having an issue with recording a macro for custom filter with cell references. The macro doesn't record a generic reference, just the cell value at the time of recording. I looked loooong and hard for the solution here, but i just can't find it. The closest i have to the answer i found here (courtsey Tom Ogilvy):- Selection.AutoFilter Field:=1, Criteria1:="=*" & Range("M13").Value _ & "*" I tried playing around with the above but come unstuck when trying to do a less than or equals to. I desperately need help to this solution to finish off a project before the weekend's out. Please, please please with extra whipped cream help. Chris P.s could someone explain what the * element of the code is for? -- chris100 ------------------------------------------------------------------------ chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166 View this thread: http://www.excelforum.com/showthread...hreadid=557087 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference cell from advanced filter | Excel Worksheet Functions | |||
Filter and show data based on a reference cell | Excel Worksheet Functions | |||
Cell reference in the auto filter custom list | Excel Discussion (Misc queries) | |||
Macro cell reference help | Excel Programming | |||
Microsoft Query - how to reference a cell value in a filter | Excel Programming |