Hi,

If isnumeric(activecell) then

activecell.value=activecell.value+1

end if


"Robert_NSBG" wrote:

This is probably very simple But Im going nutz trying to figure it out. I
have a macro that takes me to a specific cell based on a set of criteria. I
just need to add 1 (+1) to the cell that is selected. So.... based on the
criteria cell x1 is selected, I need to add 1 to the value currently in x1.
It my be x2,x3 and so on, the macro just needs to add 1 to whatever active
cell Im at??????