Search results for query: *

cheers Tony . Gavin I have foillowed a similar logic to that Gavin suggest works fine. I've tried the suggestion you made Tony, as you say it cuts out the effect of the other cells the only downside is that as the cell in sheet one chnanges the associated cell in sheet 2 although not...

thanks guys, but its not the execution of the code thats the problem, its the fact that inherantly everytime any cell chnanges the proceedure is run, so with live data streaming in, the procedure is constantly being called for the other cells which are changing and therefore taking too much of...

skip my apologies, perhaps if i start again using the code below, add a break point on the line If Not Intersect(Target, Range("B15")) Is Nothing Then then alter any cell other than a1 or b15,you see then the Private Sub Worksheet_Change(ByVal Target As Range) is called for every...

sorry reference cell A2 was as an example, so its not a case of the incorrect reference. any other other ideas?

Hi looking for some guidance on the following any help much appreciated. I have spreadsheet (sheet1) reading live data from instruments approx 1-2 times a second, the data is placed into cells A1-A230. One piece of data, in cell A2 is digital should it value change from 0 to 1 then i wish...