Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Find on nonactive sheet
I have two sheets, Roster and Skills. Both sheets have a name column that is
identical. I want to pull data from the Skills sheet and put on Roster sheet. The following code works: Sheets("Skills").Activate Columns(1).Find(Name).Activate iName = ActiveCell.Row But the following doesn't: Sheets("Roster").Activate With Sheets("Skills") .Columns(1).Find(Name).Activate iName = .ActiveCell.Row End With I get an "Activate method of range class failed" error. How can I use FInd on a non active sheet? Thanks for any help on this! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
save nonactive worksheet as a seperate workbook? | Excel Programming | |||
How do you "Find" on NonActive Page & Return Values? | Excel Programming | |||
macro in nonactive workbook | Excel Programming | |||
Deleting nonactive Sheets in Excell | Excel Programming | |||
Deleting nonactive Sheets in Excell | Excel Programming |