#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default 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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula needed - is this possible? Gary''s Student Excel Discussion (Misc queries) 0 March 28th 07 01:06 AM
Formula needed - is this possible? Kelly 1st Excel Discussion (Misc queries) 0 March 28th 07 01:00 AM
Formula help needed [email protected] Excel Worksheet Functions 0 May 24th 06 07:13 PM
Formula needed. Beertje Excel Discussion (Misc queries) 7 November 29th 05 09:54 AM
Formula Help Needed BDY Excel Discussion (Misc queries) 3 October 26th 05 05:35 PM


All times are GMT +1. The time now is 01:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"