Cells.Find Syntax

[StevenM]

The following function does not work. I assume that the syntax: wb.Sheet(1).Cells.Find
is wrong. Any suggestions?

Please Login or Register  to view this content.

Any help will be appreciated!

Steven Craig Miller

[shg]

wb.Sheets(1).Cells

or (more appropriately)

wb.Worksheets(1).Cells

[StevenM]

Thanks, that solved my problem!

[StevenM]

I would like to ask a follow-up question.

As already noted, the first function (now, Thanks!) works fine, but I can't get the second to work. Can I use a Range with Find?

Please Login or Register  to view this content.

What am I doing wrong? rg.Cells.Find doesn't seem to work.

Any suggestions would be greatly appreciated.

Steven Craig Miller

[watersev]

the question goes to find parameters: LookIn, LookAt etc.

In function the result should be: Function name equals something, Set is not used

example of function that finds row the str is located in:

Please Login or Register  to view this content.

[shg]

Yes, you can use Find within a range.

How are you trying to use this function? The use of ActiveCell is inappropriate; After must be a cell within the search range.