code to change row values a little help needed

[hattisaeed]

how can i change it for this row like b:d in the same row as the targets row

Please Login or Register  to view this content.

[bagullo]

how can i change it for this row like b:d in the same row as the targets row

Please Login or Register  to view this content.

I don't really understand what you are trying to accomplish here. Could you explain more in detail?

[Andrew-R]

Is this what you're after?

Please Login or Register  to view this content.

[hattisaeed]

works like a gem another help please then its done.....if say target value is right now 5 , i want that every time it increases by 1 or greater the row changes otherwise not for example

like if its 5 and i change it 5.9 it shouldnt change but at 6 it should

if target.value>target.value(previous) +1 then

[Andrew-R]

So far as I'm aware once you've triggered the worksheet change event the cell value is changed and the previous value is lost.

The way to get around this would be to use another column to hold the previous value. In the example below I've used column E, but you might want to use something more out of the way.

Please Login or Register  to view this content.

[snb]

Hi,

Since 17-08-2011 you started 14 threads. Only one of these you marked as 'solved'. Are the other threads still puzzling you ?

[hattisaeed]

i have one more query which i might solve the problem i m sorry i m getting annoying
is there a way i can check that the next updated value is a whole number not a decimal
like if target.value is a whole number
then do something

else it stays the same do nothing

[Andrew-R]

Yes, you can check if the target value is a whole number with:

Please Login or Register  to view this content.

If this one is now done then best heed snb's advice and mark the thread as solved, thanks.