turn off entire cell contents

Status
Not open for further replies.

chris1234567

New Member
Joined
Sep 21, 2006
Messages
12
how do i adjust the below so that it finds a t in the cell and NOT the entire cell contents without doing it manually before hand.

Set r = rng(i).Find("t")
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,114,375
Messages
5,547,575
Members
410,798
Latest member
Candyman8019
Top