macro VB

[sukhi_01]

here goes...

ive attached a VB for a macro which copys cells and then pastes them somewhere else. after this is done i select the line below the pasted cells and colour black and then the line below that and colour that black.

my macro doesnt find the next new line. it simply keeps overwriting existing data.


can anyone help.

thanks

[jasoncw]

Ok, so removing the scrolling, your code is as follows:

Please Login or Register  to view this content.

How is K696 determined to be the starting point of pasting the copied data? Is K695 the last used cell?

[sukhi_01]

cell k696 is the cell that i click on when i paste the copied cells.

[jasoncw]

Well, I understand that based on your code. However, if you want VBA to know which cell to copy the cells, then there must be some criteria you used to determine K696 was the cell to which to paste.

So what I gather, it sounds like you would like the next instance to copy into cell K712, correct? This would be 1 blank row after your data, then 2 rows that are black, then 1 blank row, then the new data?

Also, will you always be copying cells K43:P54, or will you be copying cells that you select?

[sukhi_01]

i will always be copying cells K43:P54

the next instance may not be k712 as the data range can vary.

the macro needs to find the next unused horizontal line. miss that line and paste the cells.then miss that line and then 1 row that is black and then 1 row that is yellow.

thanks.

[jasoncw]

See if this will work for you:

Please Login or Register  to view this content.

Jason