jonathanwhym
03-31-2012, 09:46 PM
Hi All,
I am fairly new to VBA and am hoping asome one can help me out here.
I would like to copy and paste a range of cells, H100-R100 and paste them in the same columns but only in rows where there is a 0 in column A.
I have around 100 rows of data which are coded with 0 or 1 depening on certain other criteeria.
Can any one help me out with a code for this, I dont know where to start and havnt been able to find anything similar to adapt online.
Cheers,
Jono
I am fairly new to VBA and am hoping asome one can help me out here.
I would like to copy and paste a range of cells, H100-R100 and paste them in the same columns but only in rows where there is a 0 in column A.
I have around 100 rows of data which are coded with 0 or 1 depening on certain other criteeria.
Can any one help me out with a code for this, I dont know where to start and havnt been able to find anything similar to adapt online.
Cheers,
Jono