Thread
:
Using Find on nonactive sheet
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Using Find on nonactive sheet
try
IName=Sheets("Skills").Columns(1).Find(Name).row
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Bonsai Bill" wrote in message
...
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!
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett