| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
return the number of rows
if it possible to write a program that will return the Row/ column
number of the cells contain certain value? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
return the number of rows
Sure.....but could you explain yourself a little bit better?
otherwise we have to guess here... cheers Carlo On Jan 31, 1:27*pm, wrote: if it possible to write a program that will return the Row/ column number of the cells contain certain value? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
return the number of rows
On Jan 31, 12:33*pm, carlo wrote:
Sure.....but could you explain yourself a little bit better? otherwise we have to guess here... cheers Carlo On Jan 31, 1:27*pm, wrote: if it possible to write a program that will return the Row/ column number of the cells contain certain value?- Hide quoted text - - Show quoted text something like a search engine: a textbox and a search button.once key in the value in the textbox and pressed "search", it will track the data in the work sheet1 and return the column number and row number in the other 2 TextBoxes. _____________ (Search) Column:______________ Row:_________________ |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
return the number of rows
Dim cell As Range
With ActiveSheet.Range("a1:a500") Set cell = .Find(2, LookIn:=xlValues) If Not cell Is Nothing Then MsgBox cell.Row & " - " & cell.Column End If End With -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ... On Jan 31, 12:33 pm, carlo wrote: Sure.....but could you explain yourself a little bit better? otherwise we have to guess here... cheers Carlo On Jan 31, 1:27 pm, wrote: if it possible to write a program that will return the Row/ column number of the cells contain certain value?- Hide quoted text - - Show quoted text something like a search engine: a textbox and a search button.once key in the value in the textbox and pressed "search", it will track the data in the work sheet1 and return the column number and row number in the other 2 TextBoxes. _____________ (Search) Column:______________ Row:_________________ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SubTotal function to return number of rows returns only zero | Excel Worksheet Functions | |||
| Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
| return cardinal number from ordinal number function - an example | Excel Programming | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
| command to return the row number or cell number in excel? | Excel Programming | |||
Linear Mode
