easy peasy, lemon squeezy (resolved)

[sykes]

Hi Guys & Gals
This is even dafter than the last one I posted.Sorry in advance.
I'm selecting a cell in vba using offset, and simply want to add 1 to the value of the cell when I run the macro.
I've tried :
ActiveCell.Offset(rowOffset:=12, columnOffset:=10).value = value +1

but it just makes the contents of the cell 1.
Help.(please)

Told you it was daft.
Head hurts again!

Sykes



_________________
....and the meek shall inherit the earth...
(but not the mineral rights!)
This message was edited by sykes on 2002-07-26 04:52

 

[Andrew Poulsom]

ActiveCell.Offset(12,10).Value = ActiveCell.Offset(12,10).Value + 1

You can leave out Value - it is the default property.

Or

With Activecell.Offset(12,10)
.Value = .Value + 1
End With

 

[AJ]

Does this work...


ActiveCell.Offset(rowOffset:=12, columnOffset:=10).value = ActiveCell.Offset(rowOffset:=12, columnOffset:=10).value + 1

 

[sykes]

Thanks both of you.
That's done the trick.
Kindest
sykes.