| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Put No. in Offset cell when value is entered
Hi all, How should I write macro code if I need no. to popup in
offset cell of column B cell if I enter any value in it. Like I want macro to put 1 in cell A1 if I put any value in cell B1 and 2 in cell A2 if I put any value in cell B2 and (3,4,5...)carry on down to row 500. I know the formula to do it but i want to do it by macro. Please can any friend can help and please also advise what changes could be make in macro code which should cover if i leave any cell blank in column B in between when putting the values in cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change color of cell when different cell has data entered | Excel Discussion (Misc queries) | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Programming | |||
| Last cell entered | Excel Worksheet Functions | |||
| Number entered into cell is dividide by 100. Not fixed by Cell For | Excel Programming | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
