ExcelBanter - Formula help needed

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula help needed (https://www.excelbanter.com/excel-discussion-misc-queries/194485-formula-help-needed.html)

basil

Formula help needed

I'm trying to edit a some macro code.
Cells.Find(What:="About Us",After:=Active .....
I would like to use a variable for the "About Us" so I can set it outside
the loop.
This code is excel 2000
Ideas please
Basil

Gary''s Student

Formula help needed

Dim s as String
s="About Us"
Cells.Find(What:=s,After:=Active .....

--
Gary''s Student - gsnu2007j

"basil" wrote:

I'm trying to edit a some macro code.
Cells.Find(What:="About Us",After:=Active .....
I would like to use a variable for the "About Us" so I can set it outside
the loop.
This code is excel 2000
Ideas please
Basil

basil

Formula help needed

Duh I tried every way but that..
Thanks much
Basil
"Gary''s Student" wrote in message
...
Dim s as String
s="About Us"
Cells.Find(What:=s,After:=Active .....

--
Gary''s Student - gsnu2007j

"basil" wrote:

I'm trying to edit a some macro code.
Cells.Find(What:="About Us",After:=Active .....
I would like to use a variable for the "About Us" so I can set it outside
the loop.
This code is excel 2000
Ideas please
Basil

All times are GMT +1. The time now is 07:33 AM.