| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row count
Hi all,
How do I write the code for the following. I need a vba to look up the value in column "a" on a sheet called "reg". If the cells value is greater than 1 i need in column "g" to input this code . =IF(A2 500,"yes","no") I want this to show the row number it is on instead of "a2" it might be a31 or something Any help would be great as I have no idea how to do this Thanks Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
![Greg[_27_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
