| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for text
Hi, I have a problem, I have a worksheet which changes shape quite a bit when different data is loaded into it and I need to be able to locate cells so I can use formula on them as part of a larger macro. How can I locate the cell which is two to the left of the cell which will always contain the words 'Total Life Sales'. I was thinking this is something to do with an active cell value = 'Total Life Sales' and then offset two the the left, but i'm not sure how to phrase it. Any help would be grand Cheers Hayley -- Hru48 ------------------------------------------------------------------------ Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895 View this thread: http://www.excelforum.com/showthread...hreadid=541618 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search for text then return text | Excel Worksheet Functions | |||
| Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
| Fun with text functions - search for text | Excel Worksheet Functions | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| Search for text, copy the number in front of text | Excel Programming | |||
![Hru48[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
