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??????

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??????

Post YOUR code for comments.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Robert_NSBG" wrote in message
...
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??????