ExcelBanter - Find method

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Find method (https://www.excelbanter.com/excel-programming/311147-re-find-method.html)

benb

Find method

That does it. Thanks.

"benb" wrote:

I want to search an entire sheet for a cell containing a value then return
the column number for that cell. I have tried variations of
n=Activesheet.Find ([value], LookIn: xlValues, LookAt: xlWhole).Column, but
any adaption I try gets a compile error. Any help?

All times are GMT +1. The time now is 10:08 AM.