| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find cell contents in range
Hi,
i am really struggling to create a macro to carry out the following. ( i am quite new to this and presently using a book but things are explained fully!) lets say cell K12 = 2245 i have a range of A2:A50 containing a list between 2220 & 2270 i need my macro to look at the value of K12. Find that value in range, and make the cell with that value active so in my list between 2220 & 2270 is an activecell where the value is 2245 i hope this can be done and hope that someone can help me. Regards, Nigel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
| Find Max and Min based on cell reference | Excel Discussion (Misc queries) | |||
| Adding contents of one cell to a range of cells. | Excel Worksheet Functions | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Threaded Mode
