| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
incrementing a cell value
how can i shorten this?
ActiveCell.Offset(0, 1 - ActiveCell.Column) = ActiveCell.Offset(0, 1 ActiveCell.Column) +1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
incrementing a cell value
What are you trying to do?
-- Don Guillett Microsoft MVP Excel SalesAid Software "Jay Fincannon" wrote in message ... how can i shorten this? ActiveCell.Offset(0, 1 - ActiveCell.Column) = ActiveCell.Offset(0, 1 ActiveCell.Column) +1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
incrementing a cell value
With Cells(ActiveCell.Row, "A")
.Value = .Value + 1 End With -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jay Fincannon" wrote in message ... how can i shorten this? ActiveCell.Offset(0, 1 - ActiveCell.Column) = ActiveCell.Offset(0, 1 ActiveCell.Column) +1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incrementing cell reference | Excel Discussion (Misc queries) | |||
| incrementing mm/yy based on value in other cell | Excel Worksheet Functions | |||
| Incrementing a cell | Excel Programming | |||
| Incrementing a cell | Excel Programming | |||
| Incrementing Cell Numbers | Excel Discussion (Misc queries) | |||
Linear Mode
