Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default find question

forgot the set

set rngFound = Cells.Find(What:="Your_Text", LookIn:=xlValues)

and instead of cells, i would use Range(rType)


--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message news:...
what would you use in place of this to find a value in a range that's 0

rngFound =Cells.Find(What:="Your_Text", LookIn:=xlValues)

--


Gary





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
How do I find my question? billnock Excel Discussion (Misc queries) 4 February 15th 10 07:59 AM
how to find my question jonsey35 Excel Discussion (Misc queries) 2 August 10th 06 06:00 PM
Find & replace question.....I believe anorton Excel Discussion (Misc queries) 13 June 4th 06 01:25 PM
find question Gary Keramidas Excel Programming 3 October 15th 05 03:40 AM
VBA .Find question Mark1 Excel Discussion (Misc queries) 6 December 3rd 04 08:29 PM


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

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"