| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro - select cell value, not permanent value
Per the macro below, how do we select the cell value and not the number value
currently in the cell? That is, we don't want it to select "2871". We want it to select what is in cell A1. If it happens to be 2871, great. If not, we want it to display whatever number is there. Range("C7").Select Selection.Copy ActiveSheet.Next.Select Selection.AutoFilter Field:=1, Criteria1:="2871", Operator:=xlAnd Range("A1").Select End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - Select cell with no text | Excel Worksheet Functions | |||
| select last cell in a dynamic list using a macro | Excel Discussion (Misc queries) | |||
| Run a macro from cell select | Excel Discussion (Misc queries) | |||
| How can I keep my cell borders permanent? | Excel Worksheet Functions | |||
| Macro for cell select | Excel Discussion (Misc queries) | |||
Threaded Mode
