P
pswanie
i need to do either one of two things...
i got about 200 cells that i need to copy and paste (from column n to c).
this is a part of the recorded macro
but the list continue to about "N380"
-----------------------------------------------------------------------------------------------
Range("N5,N8,N11,N14,N17,N20,N23,N26,N29,N32,N35").Select
-----------------------------------------------------------------------------------------------
after i copy those i need to paste it to column a (thats the closing stock
and it needs to cary over to the opening stock column.
************************************************************
1. can i select all cells with yellow colour and paste programaticly?
2. should i make that a range? (i did not do ranges before. any
help/sugestions?)
************************************************************
i also need to clear a set of cells. will colour that pruple or name that
aswell.
i got about 200 cells that i need to copy and paste (from column n to c).
this is a part of the recorded macro
but the list continue to about "N380"
-----------------------------------------------------------------------------------------------
Range("N5,N8,N11,N14,N17,N20,N23,N26,N29,N32,N35").Select
-----------------------------------------------------------------------------------------------
after i copy those i need to paste it to column a (thats the closing stock
and it needs to cary over to the opening stock column.
************************************************************
1. can i select all cells with yellow colour and paste programaticly?
2. should i make that a range? (i did not do ranges before. any
help/sugestions?)
************************************************************
i also need to clear a set of cells. will colour that pruple or name that
aswell.