Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
following coding works find, however.....
Worksheets("a").select Cells.Find(What:=zoek, After:=ActiveCell).Activate rownr = ActiveCell.Row colnr = ActiveCell.Column if I don't use Worksheets("a").select and am located in a different sheet e.g. worksheets("b").... it doesn't work. Is there a way to point to a specific sheet from within the find command no matter in which worksheet you are located at that time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find value in sheet 1 and copy matching row from sheet 2 | Excel Programming | |||
how can find sheet on workbook have so many sheet ? | Excel Worksheet Functions | |||
Find value from sheet 1 on sheet 2 and copy to an offset from there | Excel Programming | |||
Find data from one sheet in another sheet | Excel Worksheet Functions | |||
how to find and copy values on sheet 2, based on a list on sheet 1 | Excel Programming |