Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy active cell value,find the pasted value in different worksheet
hi,
I am trying to put together a simple macro to do the following job - so far I haven't succeeded: copy active cell value,go to the first worksheet in my spreadsheet, find the pasted value in there and select the row where it has found the value. can anyone help? Thx. Tom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy active cell value,find the pasted value in different worksheet
Tom,
Sub TomFind() Dim myVal As Variant On Error GoTo NotFound myVal = ActiveCell.Value Worksheets(1).Activate Cells.Find(myVal).EntireRow.Select Exit Sub NotFound: MsgBox "That value wasn't found on Worksheet 1" End Sub HTH, Bernie MS Excel MVP wrote in message oups.com... hi, I am trying to put together a simple macro to do the following job - so far I haven't succeeded: copy active cell value,go to the first worksheet in my spreadsheet, find the pasted value in there and select the row where it has found the value. can anyone help? Thx. Tom |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy active cell value,find the pasted value in different worksheet
Bernie,
thanks a lot. it does the job perfectly and at the same time it's very short and simple macro. Cheers. Tom Bernie Deitrick wrote: Tom, Sub TomFind() Dim myVal As Variant On Error GoTo NotFound myVal = ActiveCell.Value Worksheets(1).Activate Cells.Find(myVal).EntireRow.Select Exit Sub NotFound: MsgBox "That value wasn't found on Worksheet 1" End Sub HTH, Bernie MS Excel MVP wrote in message oups.com... hi, I am trying to put together a simple macro to do the following job - so far I haven't succeeded: copy active cell value,go to the first worksheet in my spreadsheet, find the pasted value in there and select the row where it has found the value. can anyone help? Thx. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to copy the active workbook name to a cell... | Excel Discussion (Misc queries) | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
How can user move in locked worksheet but not copy cell contents? | Excel Worksheet Functions | |||
macro help | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |