Formula help needed

  • Thread starter Thread starter basil
  • Start date Start date
B

basil

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
 
Dim s as String
s="About Us"
Cells.Find(What:=s,After:=Active .....
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to print only rows with data without inlcuding rows with a formula 3
Runtime Error '91' Object variable or With block variable not set 2
Macro Error Help 5
Select drop down menu option using libre-calc macro 0
Excel 2007: Help creating a macro that will run Solver? 3
display zero values at the beginning of a number. 2
creating a loop 2
Find & loop in VBA 3

Back
Top