| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 Find without select VBA
I'm trying to create a small function that returns the column number of the
Result of a Find. But I don't want to Activate or Select the result of the Find. Is there a way to do this? Google search through Groups and Web Pages was vague to say the least. cheers, Matt. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 Find without select VBA
how about something like
x=yourfind.column -- Don Guillett SalesAid Software "Matt." wrote in message ... I'm trying to create a small function that returns the column number of the Result of a Find. But I don't want to Activate or Select the result of the Find. Is there a way to do this? Google search through Groups and Web Pages was vague to say the least. cheers, Matt. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 Find without select VBA
Matt,
Try something like Dim ColNum As Integer ColNum = Cells.Find(what:="whatever").Column -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Matt." wrote in message ... I'm trying to create a small function that returns the column number of the Result of a Find. But I don't want to Activate or Select the result of the Find. Is there a way to do this? Google search through Groups and Web Pages was vague to say the least. cheers, Matt. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 Find without select VBA
Thank you Chip!
Exactly what I needed! cheers, Matt. "Chip Pearson" wrote in message ... Matt, Try something like Dim ColNum As Integer ColNum = Cells.Find(what:="whatever").Column -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Matt." wrote in message ... I'm trying to create a small function that returns the column number of the Result of a Find. But I don't want to Activate or Select the result of the Find. Is there a way to do this? Google search through Groups and Web Pages was vague to say the least. cheers, Matt. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find duplicates in Excel 2000 | Excel Discussion (Misc queries) | |||
| where can i find Formulas for excel 2000? | Excel Worksheet Functions | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| In Excel 2000, How do you select the whole of a worksheet (Select. | Excel Discussion (Misc queries) | |||
| Excel 2000 VBA: select filled cells for printing | Excel Programming | |||
Linear Mode
