blackie42
04-16-2013, 07:56 AM
Hi,
Is there a way to copy a logical test (using VBA) without having to drag it down a big worksheet?
Headers on WS so range would be from row 2 to variable
Test is - in cell F "if(B2>0,1,0), so if B2 has +ve number then 1 in F2 and if not then 0
Is there also a way to do K2 = I2 + J2 - over the used range, again without having to drag it all the way down?
many thanks for any help
Jon
Is there a way to copy a logical test (using VBA) without having to drag it down a big worksheet?
Headers on WS so range would be from row 2 to variable
Test is - in cell F "if(B2>0,1,0), so if B2 has +ve number then 1 in F2 and if not then 0
Is there also a way to do K2 = I2 + J2 - over the used range, again without having to drag it all the way down?
many thanks for any help
Jon