Excel macro to copy paste cells

[sabs2014]

I need to copy the value in C35 to cell B35. The result should be "Good" which is defined as the difference in the values being not more than 1. Cell C35 has circular references to other worksheets. What macro can I use in cell B35 so it keeps pasting the value from C35 until the difference is 1 or less? Can you help please? My knowledge of excel macros is very basic.

 

[WarPigl3t]

That makes no sense.

 

[sabs2014]

This is what I wrote =round(c35,0)
this copies the value from cell c35 to b35. now what would be the difference between writing this versus a macro?

 

[sabs2014]

The problem is that I have a circular reference in C35. Writing the above does not recognize the circular reference. I need to macro that will recognize the circular reference and break it once the difference between the values are not more than 1

 

[sabs2014]

That makes no sense.

Maybe this makes sense:

Sub CopyPasteSpecVal_()

Range("C35").Select
Selection.Copy
Range("B35").Select
ActiveSheet.PasteSpecial


'
' Keyboard Shortcut: Ctrl+Shift+B
'


I keep getting the error "Out of stack space." What am I doing wrong?