Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variables in VB Code
I'm trying to get a macro to check the contents of a field- then filter a
columb on another sheet based on that content e.g On one sheet "x" appears- this being variable- then goes to another sheet, to a defined columb and filters on "*x*" Any ideas? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variables in VB Code
turn on the macro recorder. Filter your data - use a custom criteria
contains. Now turn off the recorder Look at the recorded code. Change the criteria to get its value from the appropriate cell and hard code in the sheet name. -- Regards, Tom Ogilvy "David M" wrote in message ... I'm trying to get a macro to check the contents of a field- then filter a columb on another sheet based on that content e.g On one sheet "x" appears- this being variable- then goes to another sheet, to a defined columb and filters on "*x*" Any ideas? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Declare variables to a code? | Excel Discussion (Misc queries) | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Not at all clear on use of variables and/or object variables | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Pass Variables into Form's code | Excel Programming |