| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Value and go to that Value in Another Sheet
I, I recorded a macro to go to a value on another sheet ("Hlist") as
specified on the first sheet ("Snapshot") in cell c4, but it's not working. The recording only allows me to look for a set value ("Apples") not a value located in C4 on sheet "SnapShot"... Thanks for any suggestions. Sub Go_To_Value() ' ' Macro3 Macro ' Sheets("SnapShot").Select Range("C4").Select Selection.Copy Sheets("HList").Select Columns("D:D").Select Selection.Find(What:="Apples", After:=ActiveCell, LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find Value and go to that Value in Another Sheet
Change What:="Apples" to What:=Range("C4").Value
HTH Die_Another_Day SteveC wrote: I, I recorded a macro to go to a value on another sheet ("Hlist") as specified on the first sheet ("Snapshot") in cell c4, but it's not working. The recording only allows me to look for a set value ("Apples") not a value located in C4 on sheet "SnapShot"... Thanks for any suggestions. Sub Go_To_Value() ' ' Macro3 Macro ' Sheets("SnapShot").Select Range("C4").Select Selection.Copy Sheets("HList").Select Columns("D:D").Select Selection.Find(What:="Apples", After:=ActiveCell, LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate End Sub |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find Value and go to that Value in Another Sheet
Sry forgot the sheet name:
What:=Sheets("SnapShot").Range("C4").Value Die_Another_Day Die_Another_Day wrote: Change What:="Apples" to What:=Range("C4").Value HTH Die_Another_Day SteveC wrote: I, I recorded a macro to go to a value on another sheet ("Hlist") as specified on the first sheet ("Snapshot") in cell c4, but it's not working. The recording only allows me to look for a set value ("Apples") not a value located in C4 on sheet "SnapShot"... Thanks for any suggestions. Sub Go_To_Value() ' ' Macro3 Macro ' Sheets("SnapShot").Select Range("C4").Select Selection.Copy Sheets("HList").Select Columns("D:D").Select Selection.Find(What:="Apples", After:=ActiveCell, LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate End Sub |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find Value and go to that Value in Another Sheet
Thank you!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can find sheet on workbook have so many sheet ? | Excel Worksheet Functions | |||
| find last row in a sheet | Excel Discussion (Misc queries) | |||
| Find data from one sheet in another sheet | Excel Worksheet Functions | |||
| Find A Value In Sheet? | Excel Discussion (Misc queries) | |||
| how to find and copy values on sheet 2, based on a list on sheet 1 | Excel Programming | |||
Hybrid Mode
