Copy data in Specific column in a specific range

Hi There,

I have a worksheet that collates data from batches in sequence order. For eg: I already have data(Say eg, column A to Z) for batch 1. After batch 2 is succesful I am pullimng data from batch 2 extract file to my worksheet and adding after batch 1 data because order of column is same for all batches.

I have a macro which perfectly do this. But just a section of macro fill formulas in column A, B, J, L amd M and copy data in K column. Below is the code.

Please Login or Register  to view this content.

The below line of code does not copy the data.

Please Login or Register  to view this content.

Can someone help please?

Thanks,
Su.

Maybe. I haven't looked at anything else, just saw this flaw

Please Login or Register  to view this content.

Thanks stnkynts and Norie for your reply.

Apologise. I should have detailed before.

Yes it would be the active sheet.

bLR is storing the lowest column and lLR is the largest column count in 'Abslayer_SAP_BCN' sheet. What I am trying to do is copy K (bLR -1) (which is the value) to Range(KbLR to End of column count)